DDL Filtering for MySQL

The following options are supported for DDL filtering for MySQL DDL replication:

Option	Description
DDL INCLUDE OPTYPE CREATE OBJTYPE TABLE;	Include create table.
DDL INCLUDE OBJNAME ggvam.* EXCLUDE OBJNAME ggvam.emp*;	Exclude all the tables under the ggvam database with the emp wildcard. Note: The EXCLUDE option needs to be added together with the INCLUDE option in this parameter.
DDL INCLUDE INSTR 'XYZ' EXCLUDE INSTR 'XYZAB'	Include DDL that contains the string XYZ.
DDL INCLUDE INSTR 'WHYAB' DDL EXCLUDE INSTR ‘WHY’	Excludes DDL that contains the string WHY.
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.

Note:

EXCLUDE must always have INCLUDE statement except for EXCLUDE ALL else Extract will abend.

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