The following is an example extract parameter file.
extract extgdrds useridalias awsuser EXTTRAIL ./dirdat/rd, format release 12.1 ddl include all ddloptions addtrandata, report TABLE awsuser.*;
The following is an example replicat parameter file:
replicat repgdrds useridalias ggcsuser_alias DBOPTIONS INTEGRATEDPARAMS (parallelism 2) DISCARDFILE ./dirrpt/REPIN.dsc, APPEND Megabytes 50 DDL INCLUDE ALL ASSUMETARGETDEFS MAP awsuser.*, TARGET tpcadb.*;
Details:I have a replication from A to B and B to C. The DDL replication from A to B works well. However, the DDL operations are not replicated from B to C. The extract configuration is the same between A and B. Why?
Answer: The problem is that by default the DDL operation applied by replicat are not captured by GoldenGate. You need to use the DDLOPTIONS GETREPLICATES to enable the capture.
The basic setup is also just one line DDL INCLUDE ALL. Then, the DDLs will be replicated to the target by Oracle GoldenGate.
extract extgdrds useridalias ggadmin EXTTRAIL ./dirdat/od ddl include all ddloptions addtrandata,getreplicates, report TABLE pdb1.pmdemo.*;