1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Managing the DDL Replication Environment
  6. Removing the DDL Objects from the System

Removing the DDL Objects from the System

This procedure removes the DDL environment and removes the history that maintains continuity between source and target DDL operations.

Note:

Due to object interdependencies, all objects must be removed.

  1. Run GGSCI.
  2. Stop Extract to stop DDL capture.
    STOP EXTRACT group
  3. Stop Replicat to stop DDL replication.
    STOP REPLICAT group
  4. Change directories to the Oracle GoldenGate installation directory.
  5. Run SQL*Plus and log in as a user that has SYSDBA privileges.
  6. Disconnect all sessions that ever issued DDL, including those of Oracle GoldenGate processes, SQL*Plus, business applications, and any other software that uses Oracle. Otherwise the database might generate an ORA-04021 error.
  7. Run the ddl_disable script to disable the DDL trigger.
  8. Run the ddl_remove script to remove the Oracle GoldenGate DDL trigger, the DDL history and marker tables, and the associated objects. This script produces a ddl_remove_spool.txt file that logs the script output and a ddl_remove_set.txt file that logs current user environment settings in case they are needed for debugging.
  9. Run the marker_remove script to remove the Oracle GoldenGate marker support system. This script produces a marker_remove_spool.txt file that logs the script output and a marker_remove_set.txt file that logs environment settings in case they are needed for debugging.