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!

regarding shrink table

haleem02Apr 3 2014 — edited Apr 9 2014

Hi... I have oracle 10g db 10.2.0.4, My question is when I shrink the table (partitioned table, row movement enabled already), do I need to analyze the table after shrinking it? Is it necessary? or If I analyze after shrink table command (alter table tablename shrink space cascade;) any performance problem?

This post has been answered by Hemant Infy on Apr 4 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2014

Added on Apr 3 2014

#general-database-discussions

24 comments

9,016 views