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.