Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Table Column Editor › Oracle Constraint State Dialog

Oracle Constraint State Dialog

Use the Oracle Constraint State Dialog to specify values for an Oracle constraint.

Note: For more information about Oracle constraints see your Oracle documentation.

Deferrability

Specifies whether constraint checking in subsequent transactions can be deferred until the end of the transaction. Select one of the following values:

DEFERRED

Uses the SET CONSTRAINT(S) clause in subsequent transactions to defer checking of this constraint until after the transaction is committed.

NOTDEFERRED

Specifies to not use the SET CONSTRAINT(S) clause in subsequent transactions to defer checking of this constraint until the transaction is committed.

Initially

Establishes the default checking behavior for constraints that are deferrable. Select one of the following values:

IMMEDIATE

Checks the constraint at the end of each subsequent SQL statement.

DEFERRED

Checks the constraint at the end of subsequent transactions.

Enabled

Specifies whether to enable or disable the constraint. Select one of the following values:

ENABLE

Applies the constraint to the table data.

DISABLE

Disables the integrity constraint.

Validate

Specifies the way in which old and new data comply with the constraint. Select one of the following values:

VALIDATE

Specifies that all old and new data complies with the constraint; it guarantees that all data is valid and will continue to be valid.

NOVALIDATE

Ensures that all new operations on the constrained data comply with the constraint.

Rely

Specifies whether to use a constraint for query rewrite. Select one of the following values:

RELY

Activates an existing constraint with NOVALIDATE set for query rewrite.

NORELY

Specifies to not activate an existing constraint with NOVALIDATE set for query rewrite.

Exceptions Table

Lets you specify a table into which Oracle places the rowids of all rows that violate the constraint. The table you specify must exist on your local database.