Learn about DDL replication in MySQL.

For Oracle GoldenGate Extract for MySQL to process DDL replication, it is a requirement that the table in process exists in the database. Extract will not be able to process the DDL and abend, if that table is dropped from the database or table does not exist in the database. A warning message is issued indicating that the table is not found in the database. In such cases, you need to remove that table from the Extract list and then restart the Extract process.The DDL operation CREATE TABLE AS SELECT is not supported. Oracle GoldenGate Extract for MySQL abends with the following error when it encounters this DDL.

DDL statement "CREATE TABLE AS SELECT" is detected for table table-name at binary log
number binlog number and offset binlog offset. The DDL operation "CREATE TABLE AS SELECT"
is not supported. Execute all 'CREATE TABLE AS SELECT' DDL operations manually to the target
database and start Extract by adding Extract parameter TRANLOGOPTIONS WARNCREATEASSELECT. Once
Extract gets past the 'CREATE TABLE AS SELECT' operation, restart Extract after disabling the
parameter TRANLOGOPTIONS WARNCREATEASSELECT.