Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Database Partitioning | Partitioning Trading Networks Database
 
Partitioning Trading Networks Database
You can partition your Trading Networks database using the scripts that are located at Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\partition_support. Use the following procedure to partition your database.
Note:
Trading Networks supports partitioning only for Oracle database.
*To partition database
1. To create partitions, you have to first drop the following tables using ora_tn_drop_ddl_partition_tables.sql. If you want to retain any data existing in these tables, you have to manually migrate data to the partitioned tables using Oracle export and import utilities.
*BIZDOC
*BIZDOCATTRIBUTE
*BIZDOCARRAYATTRIBUTE
*BIZDOCCONTENT
*BIZDOCRELATIONSHIP
*DELIVERYJOB
*ACTIVITYLOG
*ARCHIVE_BIZDOC
*ARCHIVE_BIZDOCATTRIBUTE
*ARCHIVE_BIZDOCARRAYATTRIBUTE
*ARCHIVE_BIZDOCCONTENT
*ARCHIVE_BIZDOCRELATIONSHIP
*ARCHIVE_DELIVERYJOB
*ARCHIVE_ACTIVITYLOG
2. Edit ora_tn_create_ddl_partition_tables.sql and modify the partition names and the partition scheme in the sample script to suit your requirements. The sample script provided has a monthly partition scheme wherein partitions are created for every month, and data is stored in respective partitions.
3. Run ora_tn_create_ddl_partition_tables.sql to create tables with partitions.