Destroying ATG Content Administration Tables

You can destroy all ATG Content Administration, Business Control Center, ATG Portal, and ATG platform tables with this script:

<ATG10dir>/BIZUI/sql/install/db-vendor/drop_bizui_all_ddl.sql

For information on the individual scripts used to destroy tables for the ATG platform and ATG Portal, see “Destroying Database Tables” in the ATG Installation and Configuration Guide. For information about destroy scripts that are specific to other ATG applications, see the relevant product documentation.

The drop_bizui_all_ddl.sql script executes a number of subscripts:

ATG Content Administration Database Drop Scripts

The drop_bizui_all_ddl.sql script executes the following subscripts in order to destroy the database tables for ATG Content Administration:

File Name

Description

drop_internal_user_profile_ddl.sql

Destroys the tables for the extensions to the user profile specifically for ATG Content Administration.

drop_publishing_ddl.sql

Destroys the tables for the ATG Content Administration repository, which holds processes and process types.

drop_versioned_file_repository_ddl.sql

Destroys the tables for the /atg/epub/file/PublishingFileRepository, the versioned repository that is provided out-of-the-box for the following types of file assets: ATG Scenario Personalization assets (scenarios, targeters, slots, and so on), text file assets, and binary file assets.

drop_versioned_process_data_ddl.sql

Destroys the tables for the /atg/epub/process/ProcessDataRepository, the versioned repository that is provided out-of-the-box for storing information about ATG Content Administration processes.

drop_versionmanager_ddl.sql

Destroys the tables for storing versioning information.

drop_workflow_ddl.sql

Destroys the tables for the workflow portion of the ATG Content Administration repository.

These scripts are located in:

<ATG10dir>/Publishing/base/sql/uninstall/dbvendor

Business Control Center Database Drop Scripts

The drop_bizui_all_ddl.sql script executes drop_viewmapping_ddl.sql to destroy the database tables used by the Business Control Center. This script is located in:

<ATG10dir>/BIZUI/sql/uninstall/dbvendor

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

Legal Notices