1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Managing the DDL Replication Environment
  6. Disabling DDL Processing Temporarily

Disabling DDL Processing Temporarily

You must disable DDL activities before performing an instantiation or other tasks, if directed.

You can resume DDL processing after the task is finished.

  1. Disable user DDL operations on the source database.
  2. If there are previous DDL replication processes that are still active, make certain that the last executed DDL operation was applied to the target before stopping those processes, so that the load data is applied to objects that have the correct metadata.
  3. Comment out the DDL parameter in the Extract and Replicat parameter files that you configured for the new Oracle GoldenGate environment. Comment out any other parameters that support DDL.
  4. Disable the Oracle GoldenGate DDL trigger, if one is in use. See Enabling and Disabling the DDL Trigger.