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
SoftwareAG_Directory\common\db\TradingNetworks\TradingNetworks\scripts\9.8.fix1-9.9\oracle\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.