Enable DDL Replication In GoldenGate

Enable  DDL Replication In GoldenGate

In this article we will see how to enable DDL Replication in Oracle GoldeGate 12c

On Source database :

check processes

On Target database :

To Enable DDl replication in 12c we need to add DDL include all param inside extract process(EXTINT)

On Source database :

check table list on SCOTT schema

On Target database :

Check table list

On Source GGSCI :
Stop exract process (EXTINT)

Stop datapump process(DPINT)

Edit extint param file and add  DDL include all

Specify TABLE SCOTT.*   to replicate entire schema details to target 

Edit dpint param file

Add Table SCOTT.*

Start extint process

Start dpint process

Check process list 

On Source database :
Create new table

On Target database :
Check table replicated or not

Yes table definition replicated 

On source database :

Add new column

On Target database :

check columns in new_table

On Source database :

add primary key 

On target database :

check primary added or not

Yes DDL commands are replicating from Source to target database.

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment