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.
For this recipe the following setup must be in place:
Source and target databases with the
SCOTT
sample schema.DDL replication initial setup as explained in the previous recipe, Performing an initial setup required for GoldenGate DDL replication.