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.
![*](bullet.gif)
BIZDOC
![*](bullet.gif)
BIZDOCATTRIBUTE
![*](bullet.gif)
BIZDOCARRAYATTRIBUTE
![*](bullet.gif)
BIZDOCCONTENT
![*](bullet.gif)
BIZDOCRELATIONSHIP
![*](bullet.gif)
DELIVERYJOB
![*](bullet.gif)
ACTIVITYLOG
![*](bullet.gif)
ARCHIVE_BIZDOC
![*](bullet.gif)
ARCHIVE_BIZDOCATTRIBUTE
![*](bullet.gif)
ARCHIVE_BIZDOCARRAYATTRIBUTE
![*](bullet.gif)
ARCHIVE_BIZDOCCONTENT
![*](bullet.gif)
ARCHIVE_BIZDOCRELATIONSHIP
![*](bullet.gif)
ARCHIVE_DELIVERYJOB
![*](bullet.gif)
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.