ENABLE Clause

Enable constraints (or triggers)

Syntax:

   ENABLE [[NO]VALIDATE] [UNIQUE] column options [CASCADE]
   ENABLE [[NO]VALIDATE] PRIMARY KEY options [CASCADE]
   ENABLE [[NO]VALIDATE] [UNIQUE] CONSTRAINT constraint_name options [CASCADE]
   ENABLE ALL TRIGGERS

'column' can be either a single col name or several col's separated with commas,

options:

    USING INDEX storage_options
    NOSORT
    LOCAL | GLOBAL PARTITION BY RANGE (column_list)
               (PARTITION partition
                   VALUES LESS THAN (values list) 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

Related Views:

 DBA_CONSTRAINTS      ALL_CONSTRAINTS      USER_CONSTRAINTS 
 DBA_CONS_COLUMNS     ALL_CONS_COLUMNS     USER_CONS_COLUMNS