1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Configuring DDL Support
  6. Prerequisites for Configuring DDL
  7. Support for DDL Capture with Extract

Support for DDL Capture with Extract

Extract supports the DDL capture method for Oracle 11.2.0.4 or later.

Oracle databases that have the COMPATIBLE parameter set to 11.2.0.4 or higher support DDL capture through the database logmining server. This method is known as native DDL capture. Native DDL capture is the only supported method for capturing DDL from a multitenant container database.

For downstream mining, the source database must also have database COMPATIBLE set to 11.2.0.4 or higher to support DDL capture through the database logmining server.