1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Configuring DDL Support
  6. Controlling the Propagation of DDL to Support Different Topologies
  7. Propagating DDL in a Cascading Configuration

Propagating DDL in a Cascading Configuration

In a cascading configuration, use the following setting for DDLOPTIONS in the Extract parameter file on each intermediary system. This configuration forces Extract to capture the DDL from Replicat on an intermediary system and cascade it to the next system downstream. 

DDLOPTIONS GETREPLICATES, IGNOREAPPLOPS

For more information about DDLOPTIONS, see DDLOPTIONS in Reference for Oracle GoldenGate.