B2B Integration 10.5 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Database Partitioning | Deleting Archived Data from a Partitioned Database
 
Deleting Archived Data from a Partitioned Database
Use the following procedure to delete run-time data from a partitioned database.
* To delete archived data
1. Go to Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\partition_support.
2. Edit ora_tn_purge_archivedata.sql and modify the partition names in the sample script according to the partitions you have created.
3. Run ora_tn_purge_archivedata.sql to delete archived data from your partitioned database.
Copyright © 2016- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.