- As part of archive process we delete the rows from the tables from the primary storage once the data is moved to archive storage
- The delete Process leaves the fragments in the tables and as the tables grows .
- oracle provides many options to reclaim the space /defragment
- Redefine
- Shrink
what are the alternatives?