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!

reorganize the fragment blocks

ski123Sep 18 2008 — edited Sep 19 2008
Oracle 10g. I try to shrink table using alter table test_extents enable row movement; alter table test_extents shrink space; alter table test_extents disable row movement; But these commands didn't reorganize table that much. Why?

I know I can export data, truncate table, then import; OR I move all objects to new tablespace, then move them back.

Which way is the best way in the real world from DBA point view?

Thanks

S.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2008
Added on Sep 18 2008
7 comments
405 views