Inline constraints

This topic describes the conversion scope of CREATE TABLE DDL operations for inline constraints during data migration from an Oracle database to an Oracle tenant of OceanBase Database.

Syntax

Syntax of inline_constraint:

[ CONSTRAINT constraint_name ]
{ [ NOT ] NULL
| UNIQUE
| PRIMARY KEY
| references_clause
| CHECK (condition)
}
[ constraint_state ]

references_clause:
REFERENCES [ schema_name. ] object [ (column [, column ]...) ]
  [ON DELETE { CASCADE | SET NULL } ]

constraint_state:
[ [NOT] DEFERRABLE [INITIALLY {IMMEDIATE | DEFERRED}] ]
 |  INITIALLY { IMMEDIATE | DEFERRED } [ NOT ] [ DEFERRABLE ]
]
[  RELY | NORELY  ]
[ using_index_clause ]
[ ENABLE | DISABLE ]
[ VALIDATE | NOVALIDATE ]
[ exceptions_clause ]

Supported operations

• Defining constraint names by using the CONSTRAINT constraint_name clause is supported.

• Specify the NULL or NOT NULL attribute.

• Specifying the UNIQUE and PRIMARY KEY constraints is supported.

Unsupported operations

• Specifying the CHECK constraint is not supported. This option will be ignored.

• Defining the foreign key by using the references_clause clause is not supported. This clause will be ignored.

• Specifying the constraint state by using the constraint_state option is not supported. This option will be ignored.