DDL replication

GoldenGate supports the replication of all DDL commands operating at schema level. By default DDL replication is enabled on the target (Replicat) for data integrity and disabled on the source (Extract). Should you wish to perform DDL and DML replication from your source database, the DDL part must be explicitly configured through a single DDL parameter statement.

Tip

GoldenGate does not support DDL only replication. DDL replication must accompany DML replication and is enabled or disabled via the GETTRUNCATES and IGNORETRUNCATES parameters respectively.

The DDL parameter

DDL replication is configured and enabled on the Extract and Replicat process by passing multiple options to the DDL parameter. Not only can DDL operations be filtered for specific schemas and objects, but also operation types. The filtering is essentially driven through both the MAP statement and the use of wildcards in the configuration options.

Filtering

Starting with wildcards, the following DDL parameter statement...