reorganize the fragment blocks
ski123Sep 18 2008 — edited Sep 19 2008Oracle 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.