DISABLE Clause

Disable a constraint or disable ALL triggers associated with a table.

Syntax:

   DISABLE [[NO]VALIDATE] [UNIQUE] (column [,…] ) options  [CASCADE] [{DROP|KEEP} INDEX]
   DISABLE [[NO]VALIDATE] PRIMARY KEY options [CASCADE] [{DROP|KEEP} INDEX]
   DISABLE [[NO]VALIDATE] [UNIQUE] CONSTRAINT constraint_name options  [CASCADE] [{DROP|KEEP} INDEX]
   DISABLE 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
drop constraint - clause
enable - Enable a constraint
ALTER TABLE

Related Views:

 DBA_CONSTRAINTS    ALL_CONSTRAINTS    USER_CONSTRAINTS 
 DBA_CONS_COLUMNS   ALL_CONS_COLUMNS   USER_CONS_COLUMNS