Using a Partitioned Database for Archiving Run-time Data
Database partitioning enhances the process of archiving data from production tables to archive tables. Use the following procedure to archive run-time data.
To partition database for archiving data
1. Go to Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\partition_support.
2. Run ora_tn_create_ddl_temp_tables.sql to create temporary tables.
3. Edit ora_tn_archive_runtime_data.sql and modify the partition names in the sample script according to the partitions you have created.
4. Run ora_tn_archive_runtime_data.sql to archive run-time data.