B2B Integration 10.2 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Database Partitioning | Using a Partitioned Database for Archiving Run-time Data
 
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.
Copyright © 2016- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.