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. Complete the steps for scheduling a maintenance script.

   For more information, see Scheduling Maintenance Scripts in the Job Scheduler.

2. From the Schedule Job page, select Reset Environment.