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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.