Pages

Reclaim unused Space




  • 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
     but any of these features requires ample amount of data base green zones which is not viable for high availability platforms.

what are the alternatives?