Reallocate Tablespace

Use the Reallocate Tablespace maintenance script to free unused and space in your tables. Reallocating tablespace enables you not to exceed the space quota defined for a specific table and free up space available for the storage of data.

Note:

Do not load data when executing this script.

To run the Reallocate Tablespace script:

  1. From the Data Integration home page, and then from the Actions menu, then from the Other actions drop-down, select System Maintenance Tasks.

  2. From the System Maintenance Tasks page, click Image shows the Arrow icon. to the right of the Reallocate Tablespace task.

  3. From the Run Script: Reallocate Table page, click OK.