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.