Create a relational table

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_properties option is supported. For more information, see Define columns in relational tables.

• Creating partitions by using the table_properties option is supported. For more information, see Create a partition.

Ignored clauses and options

• The immutable_table_clauses clause for defining the drop time of immutable tables.

• The blockchain_table_clauses clause for defining the maximum allowed idle state period and the least number of active days for a blockchain table.

• The DEFAULT COLLATION collation_name option for specifying the default collation.

• The ON COMMIT DROP DEFINITION option for defining transaction-level private temporary tables and the ON COMMIT PRESERVE DEFINITION option for defining session-level global temporary tables. Example:

  CREATE PRIVATE temporary TABLE PTT_tab1(a number) ON COMMIT DROP DEFINITION;
  CREATE PRIVATE temporary TABLE PTT_tab1(a number) ON COMMIT PRESERVE DEFINITION;