O'Reilly logo

Oracle GoldenGate 11g Complete Cookbook by Ankur Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required