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 schedule the script to run now, see Scheduling a Job to Run Now.
To schedule the script to run later, see Scheduling a Job to Run Later.