OGG-05145
DDL statement "CREATE TABLE AS SELECT" is detected for table {0}.{1} at binary log number {2} and offset {3}. 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.
Cause
'CREATE TABLE AS SELECT' DDL is not supported.
Action
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.