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

Enabling and Disabling the DDL Trigger

You can enable and disable the trigger that captures DDL operations without making any configuration changes within Oracle GoldenGate.

The following scripts control the DDL trigger.

  • ddl_disable: Disables the trigger. No further DDL operations are captured or replicated after you disable the trigger.

  • ddl_enable: Enables the trigger. When you enable the trigger, Oracle GoldenGate starts capturing current DDL changes, but does not capture DDL that was generated while the trigger was disabled.

Before running these scripts, disable all sessions that ever issued DDL, including those of the Oracle GoldenGate processes, SQL*Plus, business applications, and any other software that uses Oracle. Otherwise the database might generate an ORA-04021 error. Do not use these scripts if you intend to maintain consistent DDL on the source and target systems.