This topic describes the conversion scope of CREATE TABLE DDL operations for creating relational tables during data migration from an Oracle database to an Oracle tenant of OceanBase Database.
Syntax
relational_table:
[ (relational_properties) ]
[ immutable_table_clauses ][ blockchain_table_clauses ][ DEFAULT COLLATION collation_name ]
[ ON COMMIT { DROP | PRESERVE } DEFINITION ][ ON COMMIT { DELETE | PRESERVE } ROWS ]
[ physical_properties ]
[ table_properties ]
immutable_table_clauses:
[ immutable_table_no_drop_clause ]
[ immutable_table_no_delete_clause ]
immutable_table_no_drop_clause:
NO DROP [ UNTIL integer DAYS IDLE ]
immutable_table_no_delete_clause:
NO DELETE ( [ LOCKED ] | ( UNTIL integer DAYS AFTER INSERT [LOCKED] ) )Supported operations
Defining columns of a relational table by using the
relational_propertiesoption is supported. For more information, see Define columns in relational tables.Creating partitions by using the
table_propertiesoption is supported. For more information, see Create a partition.
Ignored clauses and options
The following clauses and options will be ignored and will not be resolved or converted when they are specified in the synchronized DDL statements.
The
immutable_table_clausesclause for defining the drop time of immutable tables.The
blockchain_table_clausesclause for defining the maximum allowed idle state period and the least number of active days for a blockchain table.The
DEFAULT COLLATION collation_nameoption for specifying the default collation.The
ON COMMIT DROP DEFINITIONoption for defining transaction-level private temporary tables and theON COMMIT PRESERVE DEFINITIONoption for defining session-level global temporary tables. Sample code:CREATE PRIVATE temporary TABLE PTT_tab1(a number) ON COMMIT DROP DEFINITION; CREATE PRIVATE temporary TABLE PTT_tab1(a number) ON COMMIT PRESERVE DEFINITION;