Post-cleanup activities
Perform the following tasks after you complete the offline database cleanup process.
Reclaiming tablespaces
During the offline database cleanup process, temporary swap tables are created. The tablespace still remains occupied and must be reclaimed. The task of reclaiming the tablespace is performed by the database administrator and differs according to the type of database — whether Oracle or SQL Server.
Invalid macro parameters used for the [tab] macro.
Invalid macro parameters used for the [tab] macro.
Gathering and comparing metrics
After running the cleanup process, it is worthwhile to capture the current size of the database tables so that these sizes can be compared to the pre-cleanup sizes. To capture database table sizes, run one of the provided scripts, depending on your database type — either or .
Compare the resulting CSV file to the CSV file that was generated before you ran the cleanup process.