Deleting Run-time Data from a Partitioned Database
Use the following procedure to delete run-time data from a partitioned database.
To delete run-time data
1. Go to
SoftwareAG_Directory\common\db\TradingNetworks\TradingNetworks\scripts\9.8.fix1-9.9\oracle\partition_support
2. Edit ora_tn_purge_runtimedata.sql and modify the partition names in the sample script according to the partitions you have created.
3. Run ora_tn_purge_runtimedata.sql to delete run-time data from the partitions.