Name
Constraint_State_Clause
Synopsis
{DEFERRABLE [INITIALLY {IMMEDIATE | DEFERRED}
| NOT DEFERRABLE [INITIALLY IMMEDIATE ]
}
{ INITIALLY IMMEDIATE [[NOT] DEFERRABLE]
| INITIALLY DEFERRED
}
[RELY | NORELY]
[USING INDEX
[INITRANS integer]
[MAXTRANS integer]
[PCTFREE integer]
[TABLESPACE tablespace_name]
[NOSORT]
[LOGGING | NOLOGGING]
[Storage_Clause]
[ENABLE | DISABLE]
[VALIDATE | NOVALIDATE]
[EXCEPTIONS INTO [schema.]table_name]
]Allows a constraint to be selectively enabled or disabled.
Keywords
- DEFERRABLE
Specifies that the constraint may be deferred. A deferred constraint will not be checked until the transaction is committed.
- INITIALLY IMMEDIATE
Specifies that the constraint should initially be evaluated immediately after the execution of each DML statement. The SET CONSTRAINTS statement may be used within a transaction to alter this behavior.
- INITIALLY DEFERRED
Specifies that the constraint should initially be checked only when a transaction is committed. The SET CONSTRAINTS statement may be used within a transaction to alter this behavior.
- NOT DEFERRABLE
Specifies that constraint checking may not be deferred for this constraint.
- RELY
Specifies that a materialized view (or snapshot) will be eligible for query rewrite even if an associated constraint is not validated. This keyword is valid only for materialized views.
- NORELY
Specifies that a materialized view (or snapshot) will be not be eligible for query rewrite if an associated constraint is not validated. This keyword is valid only ...