Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shrink cascade, what happen with indexes?

553681Dec 13 2007 — edited Dec 14 2007
Hi,

alter table xxx shrink cascade;

This stantement reorganize the associate indexes of table xxx too !

HWM of table it's set to min possible, but what happen with HWM of index?
The extentions are compressed, but the space it's back to tablespace?

Thanks to all.
Regards.
Francesco
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2008
Added on Dec 13 2007
19 comments
4,038 views