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