Dear Readers,
In this article we will see how to disable DDL Replication in Oracle GoldeGate 12c.
On Source database :
check processes
|
1 2 3 4 5 |
GGSCI (gg.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPINT 00:00:00 00:00:04 EXTRACT RUNNING EXTINT 00:00:10 00:00:08 |
On Target database :
Check processes
|
1 2 3 4 |
GGSCI (gg2.orcl.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPINT 00:00:00 00:00:03 |
To Disable DDL replication in 12c we need to add DDL include all param inside extract process(EXTINT)
On Source GGSCI :
Stop exract process (EXTINT)
|
1 2 3 4 |
GGSCI (gg.orcl.com) 2> stop extint Sending STOP request to EXTRACT EXTINT ... Request processed. |
Edit the extint param file and comment DDL include all
|
1 2 |
GGSCI (gg.orcl.com) 3> edit param extint --DDL include all |
Start the extint processes
|
1 2 3 |
GGSCI (gg.orcl.com) 4> start extint Sending START request to MANAGER ... EXTRACT EXTINT starting |
Check processes
|
1 2 3 4 5 |
GGSCI (gg.orcl.com) 5> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPINT 00:00:00 00:00:07 EXTRACT RUNNING EXTINT 00:01:41 00:00:01 |
Create table on source database
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SYS> conn scott/tiger Connected. SCOTT> select * from tab; TNAME TABTYPE CLUSTERID ------- ---------- DEPT TABLE NEW_TABLE TABLE SCOTT> create table New_table2(sno number); Table created. SCOTT> select * from tab; TNAME TABTYPE CLUSTERID ------- ---------- DEPT TABLE NEW_TABLE TABLE NEW_TABLE2 TABLE |
Check on Target database :
|
1 2 3 4 5 6 7 |
SYS> conn scott/tiger Connected. SCOTT> select * from tab; TNAME TABTYPE CLUSTERID ------- ---------- DEPT TABLE NEW_TABLE TABLE |
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
Loading...
