Table Reorg - Pre-requisites

1. No backup should be running in the system

select * from v$backup.

2. No archiving job should be running in the system, check from SM37


3. The size of oraarch (saparch) - should be free at least to the size of Table to be reorganized. Normally 30-40 GB free

4. Size of Table space PSAPSR3 should by 120% of the size of table to be reorganized.

5. Run the stats and check the table size before and after Reorg.