Wednesday, September 12, 2007

oracle: how to defragment a table

ALTER TABLE emp ENABLE ROW MOVEMENT;
ALTER TABLE emp SHRINK SPACE COMPACT;
ALTER TABLE emp SHRINK SPACE;