GoldenGate DDL replication

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.