Destroying Database Tables for ATG Portal

The reset file in the <ATG10dir>/Portal/install/database-vendor directory runs a set of scripts that drop the database tables for Oracle ATG Web Commerce Portal. Use the following syntax to run the reset file appropriate for your DBMS:

Note: Once you run the reset file, you must run the install file again to use your database with the Portal Application Framework. See Creating Database Tables for ATG Portal for details.

Note: Entering passwords as command line arguments entails some security risks. Do not enter passwords as command line arguments in situations where security is a top priority.

The drop scripts for Oracle ATG Web Commerce Portal are located in the following directories:

<ATG10dir>/Portal/paf/sql/uninstall/database-vendor
<ATG10dir>/Portal/gear_dir/sql/uninstall/database-vendor

Note that the lines in these files that drop the DSS, DPS, and DAS tables are commented out by default as a safety measure. To drop those tables, uncomment the lines before running the script.

Script name

Purpose

drop_alert_ddl.sql

Destroys tables for the Alerts Gear

drop_bookmarks_ddl.sql

Destroys tables for the Bookmarks Gear

drop_calendar_ddl.sql

Destroys tables for the Calendar Gear

drop_communities_ddl.sql

Destroys tables for the Communities Gear

drop_discussion_ddl.sql

Destroys tables for the Discussion Gear

drop_docexch_ddl.sql

Destroys tables for the Document Exchange Gear

drop_membership_ddl.sql

Destroys tables for storing membership requests

drop_paf_mappers_ddl.sql

Destroys tables used by sample mappers to record portal events

drop_portal_ddl.sql

Destroys tables for the Portal Application Framework

drop_poll_ddl.sql

Destroys tables for the Poll Gear

drop_profile_ddl.sql

Destroys tables for storing portal profile data

drop_soapclient_ddl.sql

Destroys the tables for the Web Services Client Gear

Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.

Legal Notices