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.