Recreating Database Objects From Which You Purge
After you purge records from your database, ask your database administrator to export and import the tables and indexes from which you purged data by performing the following steps. By recreating these objects, you reduce the memory each object occupies in the tablespace thus increasing system performance.
Contact Oracle Worldwide Customer Support Services for further details.
To recreate database objects from which you purged:
1. Prevent users from accessing the database.
2. Analyze the size required for each table and index that should be recreated. Refer to the following:
- Purge Statistics Report. Provides summary information on which tables you purged from and how many records you purged from each table
- Oracle Payables Applications Technical Reference Manual. Provides information on which indexes Payables requires for each database table
3. Export the unpurged data from the tables you are going to drop and recreate.
4. Drop the indexes and tables from the database.
5. Recreate each table and index. Ideally, the initial extent of each object will provide enough space to store all data in that object, and the next extent should be somewhat smaller. Do not use a percentage increase for next extents. Depending on your database configuration, you may want to create certain objects on different tablespaces to maximize the input/output efficiency of your storage devices. For example, you may want to separate large, heavily-used tables and indexes into separate tablespaces.
6. Import the unpurged data back into the database and verify the results.
7. Bring users back online.
See Also
Purge Reports
Reports (Oracle Payables Applications Technical Reference Manual)