This section describes how to destroy the Oracle ATG Web Commerce database tables. When you destroy database tables, you need to destroy them in the opposite order you used for creating them.
To destroy all core Commerce tables, run the drop_dcs_ddl.sql script from the following directory:
<ATG10dir>/DCS/sql/install/database-vendor
The drop_dcs_ddl.sql script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:
<ATG10dir>/DCS/sql/uninstall/database-vendor
File Name | Description |
|---|---|
| Destroys the schema for the Claimable repository |
| Destroys the tables for the credit card profile extensions |
| Destroys the table for handling shopping cart events |
| Destroys the tables for the inventory system |
| Destroys the tables for the purchase process |
| Destroys the tables that contain order markers |
| Destroys the tables for the price lists |
| Destroys the tables for the product catalog |
| Destroys the tables for the promotions |
| Destroys the views for reporting |
| Destroys additional views for reporting |
| Destroys additional views for reporting |
| Destroys additional views for reporting |
| Destroys the tables for the Giftlist Services |
| Destroys the tables for the promotions profile extensions |
| Destroys the tables for the contracts repository |
| Destroys the tables for the invoice repository |
| Destroys the tables for the organization extensions |
Destroying Motorprise Reference Application Tables
You can destroy the database tables for the Oracle ATG Web Commerce platform, Oracle ATG Web Commerce, and the Motorprise reference application by running a single script, drop_motorpriseall_ddl.sql, from the following directory:
<ATG10dir>/MotorpriseJSP/sql/install/database-vendor
Alternatively, to destroy just the database tables for the Motorprise reference application, run the drop_motorprise_ddl.sql script from the same directory. If necessary, you can run each subscript individually:
Script name | Purpose |
|---|---|
| Destroys tables for the Motorprise profile extensions for authorization |
| Destroys tables for the Motorprise catalog extensions |
| Destroys tables for the Motorprise profile extensions for order details |
| Destroys tables for the Motorprise product catalog extensions for German content |
| Destroys tables for the Motorprise product catalog extensions for Japanese content |
