Shrinking and Compressing a Tablespace

How To

In order to optimize storage space, the user may choose to compress the tablespace by moving the data pages and BLOB frames to the beginning of the file or shrink the tablespace by changing the number of free pages remaining in each of the files in the tablespace. The number of tailing free pages you want the tablespace to contain should be less than the number of free pages that are being replaced. By replacing the number of tailing free pages in a tablespace the total number of free pages in each of the files in the tablespace is altered.


Related topic:

Altering a Tablespace