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 the Oracle compatible mode 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 relational table columns by using the relational_properties clause is supported. For more information, see Define relational table columns.

• Only partitions can be created by using the table_properties clause. 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 idle retention period and the number of days that must be in active state for blockchain tables.

• 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;