To shrink or compress a tablespace:

  1. Select the tablespace that you want to compress or shrink. The Properties page is displayed.

  2. Click the Alter TS button on top of the window. The Alter Tablespace dialog box is displayed.

  3. To compress the tablespace, select the Compress Tablespace option button.

  4. To reduce the tailing or remaining free pages in tablespace files, select the Shrink Tablespace option button.

  5. If you want to reduce the tailing or remaining free pages in the files of the tablespace, enter the number of tailing free pages you want the files in the tablespace to contain.

  6. To compress and shrink the tablespace:

    1. Select the Compress and Shrink Tablespace option button.

    2. Enter the number of tailing free pages you want the tablespace to contain in the text field.

  7. In order to check the consistency of the database before changes are made to the tablespace, click the Check tablespace before action checkbox

  8. Click the Confirm button. The Alter Tablespace confirmation dialog box is displayed.

  9. Click OK.


Related topic:

Shrinking and Compressing a Tablespace