File and Move Data to Shrink Datafiles

Abstract

A system, method, and computer-readable medium for consolidating all the currently used areas to the beginning of the datafile by performing a datafile reorganization operation. With this consolidation, more space can be recovered from the datafile. More specifically, with the consolidation, because each used area can contain extents related to several different segments, locating all the segments that have extents in a used area and relocate these segments to lower addresses in the datafile can be challenging.

What is claimed is: 
     
         1 . A computer-implementable method for performing a datafile reorganization operation, comprising:
 locating all segments that have extents in a used area of the datafile; and   relocating the segments that have extents in a used area to lower addresses in the datafile, the relocating the segments consolidating all unused extents within the datafile.