Reallocate Tablespace

Free unused and space in your tables enabling you to free up space available for the storage of data.

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. Click Application, then Jobs, and then Schedule Jobs.

  2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

  3. To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .

    To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.

  4. From the Integration Maintenance Script page, click Image shows Select icon. to the right of the Reallocate Tablespace task to schedule.

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