Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Archiving and Deleting Documents | Using a Partitioned Database for Archival and Deletion
 
Using a Partitioned Database for Archival and Deletion
Apart from using the Basic and Extended methods for archival and deletion, you can partition your database for archiving and deleting data using the scripts that are located at Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\partition_support. Partitioning logically separates one set of data from another, thereby enhancing the process of archiving data from production tables to archive tables. For more information on partitioning your database for archival and deletion, see Partitioning Trading Networks Database.
Note:
For BizDocUniqueKeys, ARCHIVE_BizDocUniqueKeys, EDITracking, and ARCHIVE_EDITracking tables, Trading Networks supports only the Basic and Extended methods of archival. For deletion, use wm.tn.archive:purgeBizdocUniqueKeysData and wm.tn.archive:purgeEDITrackingData services respectively. For more information on these services, see webMethods Trading Networks Built-In Services Reference.