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.
GoldenGate does not support DDL only replication. DDL replication must accompany DML replication and is enabled or disabled via the
IGNORETRUNCATES parameters respectively.
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 ...