reorg compact combines the functions of reorg reclaim_space and reorg forwarded_rows. Use reorg compact when:
You do not need to rebuild an entire table (reorg rebuild); however, both row forwarding and unused space from deletes and updates may be affecting performance.
There are a large number of forwarded rows. See “Using reorg compact to remove row forwarding”.
The syntax for reorg compact is:
reorg compact table_name partition partition_name
with {resume, time = no_of_minutes}]
If you specify a partition, only the part of the table that resides on that partition is affected.
For information about the resume and time options, see “resume and time options for reorganizing large tables”.
