Setting up a GoldenGate DDL replication and verifying the changes

In a default GoldenGate setup, all DMLs are captured in the source environment and all DMLs and DDLs are applied in the target environment. However, unless you start extracting the DDL statements in source, there would not be any DDL statements to apply at the target environment by replicat. Extracting the DDLs in source requires some extra configuration. In this recipe we will look into the additional parameters/setup required for performing the DDL replication.

Getting ready

For this recipe the following setup must be in place:

  1. Source and target databases with the SCOTT sample schema.
  2. DDL replication initial setup as explained in the previous recipe, Performing an initial setup required ...

Get Oracle GoldenGate 11g Complete Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.