Enable DDL Replication In GoldenGate

Share via:

Dear Readers,

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

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

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

Add Comment