DDL Filtering for Replication

The following options are supported for MySQL DDL replication:

Option	Description
DDL INCLUDE OPTYPE CREATE OBJTYPE TABLE;	Include create table.
DDL INCLUDE OBJNAME ggvam.*	Include tables under the ggvamdatabase.
DDL EXCLUDE OBJNAME ggvam.emp*;	Exclude all the tables under the ggvam database and table name starting with the empwildcard.
DDL INCLUDE INSTR ‘XYZ’	Include DDL that contains this string.
DDL EXCLUDE INSTR ‘WHY’	Excludes DDL that contains this string.
DDL INCLUDE MAPPED	MySQL DDL uses this option and should be used as the default for Oracle GoldenGate MySQL DDL replication. DDL INCLUDE ALL and DDL are not supported.
DDL EXCLUDE ALL	Default option.

For a full list of options, see DDL in Reference for Oracle GoldenGate.