This topic describes the conversion scope and incompatibilities of DDL synchronization during data migration from an Oracle database to the Oracle compatible mode of OceanBase Database.
Supported DDL operations
CREATE TABLE: For more information, see CREATE TABLE.CREATE INDEX: For more information, see CREATE INDEX.ALTER TABLE: For more information, see ALTER TABLE.DROP TABLE: For more information, see DROP TABLE.DROP INDEX: For more information, see DROP INDEX.RENAME OBJECT: For more information, see RENAME OBJECT.TRUNCATE TABLE: For more information, see TRUNCATE TABLE.
Unsupported operations
CREATE TABLE AS SELECT (CTAS)
DDL operations not listed in this topic are not supported.
Incompatibilities
For more information, see DDL incompatibilities between an Oracle database and the Oracle compatible mode of OceanBase Database.