How to Free Disk Space
If the disk space for your data location becomes low, follow these steps:
1. Extend the database to a new location. For details, see the chapter "Using Alternate Locations."
2. Copy a table into the new location using CREATE TABLE AS SELECT statement.
3. Drop the old table.
Disk space is freed to the operating system.