1. Administering Data Management
  2. System Maintenance Tasks
  3. Reallocate Tablespace

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 execute the Reallocate Tablespace script:

  1. On the Workflow tab, under System Maintenance Tasks, select Reallocate Tablespace script and then click Execute.

  2. On the Execute Script page, click OK.