• Arun Kumar

Oracle Golden Gate DDL Replication

Take any one of our previous replication examples and add below in the extract parameter file

DDL INCLUDE MAPPED

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

Now on the source side, try to add a new column to the table and check if the same has been added on target or now

ALTER TABLE table_name ADD col_namecol_definition;

Setup DDL Replication


Create tables on source proddb

oracle golden gate ddl replication - create table

Create table on target with same structure as source

oracle golden gate ddl replication - setup ddl replication

On source, add supplemental logging for the table

oracle golden gate ddl replication - supplemental logging

Add the extract

oracle golden gate ddl replication - add the extract

Register the extract and edit parameters

oracle golden gate ddl replication - register the extract and edit parameters

Add data pump process

oracle golden gate ddl replication - data pump process
oracle golden gate ddl replication - data pump process parameters

Start the extract and pump process

oracle golden gate ddl replication - start extract on source

Let us add replicat on target

oracle golden gate ddl replication - add replicat on target

Below are the parameters used for rep12

oracle golden gate ddl replication - edit replicate parameters

Start replicat process on target

oracle golden gate ddl replication - start replicat process on target

Let us add a column on the source table

oracle golden gate ddl replication - edit source table

Check the extract stats

oracle golden gate ddl replication - stats extract

Check the pump stats

oracle golden gate ddl replication - stats pump

Check the replicat stats

oracle golden gate ddl replication - stats replicat

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

oracle golden gate ddl replication - check target table definition


1,206 views

Recent Posts

See All