Trading Networks 10.11 | Administering Trading Networks | Database Partitioning | Partitioning Trading Networks Database
 
Partitioning Trading Networks Database
You can partition your Trading Networks database using the scripts that are located at
SoftwareAG_Directory\common\db\TradingNetworks\TradingNetworks\scripts\9.8.fix1-9.9\oracle\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.