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!

Difference between shrink space & shrink space compact & shrink space cascade

966815Aug 2 2017 — edited Aug 2 2017

hello,

can u explain what is difference between "alter table table_name shrink space" and "alter table table_name shrink space compact" and "alter table table_name shrink space cascade" with good example. which command rebuild the indexes?

Kind Regards,

Mohammed Irfanullah

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2017
Added on Aug 2 2017
7 comments
3,292 views