B2B Integration : Trading Networks Administrator's Guide : Database Partitioning : Dropping a table in a Partitioned Database
Dropping a table in a Partitioned Database
Use the following procedure to drop tables in a partitioned database.
Note:  
Do not use Database Component Configurator to drop partitioned tables.
To drop a table
1. Go to Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\partition_support.
2. Run ora_tn_drop_ddl_temp_tables.sql to drop all the temporary tables.
3. Run ora_tn_drop_ddl_partition_tables.sql to drop all the partitioned tables.
Copyright © 2016- 2017 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback