The reset file in the <ATG9dir>/Portal/install/
database-vendor
directory runs a set of scripts that drop the database tables for ATG Portal. Use the following syntax to run the reset file appropriate for your DBMS:
reset-db2
userid password database
reset-mssql
userid
password
host
database
reset-oracle
userid
password
database
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.
The drop scripts for ATG Portal are located in the following directories:
<ATG9dir>/Portal/paf/sql/uninstall/database-vendor
<ATG9dir>/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 |
---|---|
| Destroys tables for the Alerts Gear |
| Destroys tables for the Bookmarks Gear |
| Destroys tables for the Calendar Gear |
| Destroys tables for the Communities Gear |
| Destroys tables for the Discussion Gear |
| Destroys tables for the Document Exchange Gear |
| Destroys tables for storing membership requests |
| Destroys tables used by sample mappers to record portal events |
| Destroys tables for the Portal Application Framework |
| Destroys tables for the Poll Gear |
| Destroys tables for storing portal profile data |
| Destroys the tables for the Web Services Client Gear |