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
SoftwareAG_Directory\common\db\TradingNetworks\TradingNetworks\scripts\9.8.fix1-9.9\oracle\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.