Name
Constraint_State_Clause
Synopsis
{DEFERRABLE [INITIALLY {IMMEDIATE | DEFERRED} | NOT DEFERRABLE [INITIALLY IMMEDIATE ] } { INITIALLY IMMEDIATE [[NOT] DEFERRABLE] | INITIALLY DEFERRED } [RELY | NORELY] [USING INDEX [INITRANSinteger
] [MAXTRANSinteger
] [PCTFREEinteger
] [TABLESPACEtablespace_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 ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.