ENABLE Clause

Enable constraints (or triggers)

Syntax:

   ENABLE [[NO]VALIDATE] [UNIQUE] (column [,…] ) options [CASCADE] [{DROP|KEEP} INDEX]
   ENABLE [[NO]VALIDATE] PRIMARY KEY options [CASCADE]  [{DROP|KEEP} INDEX]
   ENABLE [[NO]VALIDATE] CONSTRAINT constraint_name options [CASCADE]  [{DROP|KEEP} INDEX]
   ENABLE ALL TRIGGERS

Options:

    USING INDEX storage_options
    USING INDEX (create_index_statement)
    SORT | NOSORT
    LOCAL | GLOBAL PARTITION BY RANGE (column_list)
               (PARTITION partition
                   VALUES LESS THAN (value [,value…]) storage_options
    EXCEPTIONS INTO [schema.]table

storage_options:
       PCTFREE int
       PCTUSED int
       INITTRANS int
       MAXTRANS int
       STORAGE storage_clause
       TABLESPACE tablespace
       LOGGING|NOLOGGING

notes:
If more than one option is specified - you only need the first "USING INDEX"

If EXCEPTIONS INTO is specified it should be the last option listed.

Related Commands:

constraint - clause
disable
- Disable a constraint
drop - clause
ALTER TABLE

Related Views:

DBA_CONSTRAINTS    ALL_CONSTRAINTS    USER_CONSTRAINTS
DBA_CONS_COLUMNS   ALL_CONS_COLUMNS   USER_CONS_COLUMNS


© Copyright SS64.com 1999-2014
Some rights reserved