Shervin@OOW

Shervin@OOW

TIP 110# : GoldenGate DDL replication

I have to setup a DDL replication for a customer and as usual I use include to filter schema which I want to be replicated as below :

DDL &
INCLUDE ALL OBJNAME "SCHEMA1.*" &
INCLUDE ALL OBJNAME "SCHEMA2.*" &
EXCLUDE OBJTYPE SEQUENCE
 
Interesting enough, I see that GoldenGate does not capture DDL although the filter should work fine. The following is reported in GoldenGate log with my surprise :
 
Oracle GoldenGate Capture for Oracle, ext_test.prm:  DDL operation excluded [not included by any filter]
, optype [CREATE], objtype [TABLE], objowner [SCHEMA1], objname [TAB]
 
 
The same situation does occur using different DDL options such as MAPPED. Further investigation revealed that it is a bug which is reported in Doc ID 1475618.1 and the workaround is not to use " for schema, in other words, the following works with no issue :
 
 
 DDL &
INCLUDE ALL OBJNAME SCHEMA1.* &
INCLUDE ALL OBJNAME SCHEMA2.* &
EXCLUDE OBJTYPE SEQUENCE
 
 
So no " for DDL options when you setup DDL for GoldenGate. Hope this simple tips helps.


No comments: