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.