Oracle Golden Gate DDL Replication

Data Definition Language (DDL) replication is the process of replicating database schema changes, such as creating, dropping, and modifying tables, views, and other objects, from one database to another. In this article, we will discuss the basics of Oracle Golden Gate DDL replication

• Quick start with DDL Replication

• Configure Golden Gate DDL Replication

• Test DDL Replication

Quick start with DDL Replication

You can enable DDL replication by simply adding below to extract parameter file

DDL INCLUDE MAPPED

Note: Do not use DDL INCLUDE ALL until it is really required.

Now if you add new column on source table, it will reflect on target too

ALTER TABLE table_name ADD col_namecol_definition;

Configure Golden Gate DDL Replication

Create a test table on source for the purpose of testing DDL replication

Create table on target with same structure as source

On source, add supplemental logging for the table

Add the extract

Register the extract and edit parameters to add DDL INCLUDE MAPPED

Add data pump process

Start the extract and pump process

Let us add replicat on target

Below are the parameters used for rep12

Start replicat process on target

Test DDL Replication

Let us add a column on the source table

Check the extract stats

Check the pump stats

Check the replicat stats

Now check the target table if the new column is added or not