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 Oracle 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