DDL synchronization between Oracle-compatible tenants of OceanBase Database

Supported DDL operations

• CREATE TABLE

  You can create partitioned tables but cannot use CREATE TABLE AS SELECT to create tables. HASH-, RANGE-, and LIST-partitioned tables, and HASH-, RANGE-, and LIST-subpartitioned tables are supported.

• DROP TABLE

• TRUNCATE TABLE

• RENAME TABLE and ALTER TABLE RENAME

• ALTER TABLE ADD COLUMN

• ALTER TABLE CHANGE COLUMN

  Notice

  You can increase the column length, but you cannot modify the column type.

• CREATE INDEX

• DROP INDEX

• Adding or dropping comments on tables or columns

Limitations

• If a table to be synchronized involves unsupported DDL operations, the migration task may be interrupted, resulting in unrecoverable data inconsistencies.

• Frequent DDL operations on a single table are not supported. Perform the next DDL operation only after the Store has completed the current operation based on the log position. Otherwise, the Store may exit unexpectedly or cause unrecoverable data errors.

• Ensure that no DDL operations are performed for a period before you create a Store or while the Store is starting. If logs need to be pulled from an earlier point, ensure that no DDL operations are performed between the log pull point and the current time. Otherwise, the Store may exit unexpectedly or cause unrecoverable data errors.

• The original and new table names in the RENAME TABLE statement must both be included in the list of tables to be synchronized.

• A table creation DDL operation that involves the CASE WHEN INDEX clause cannot be synchronized.