DISABLE Clause

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

Syntax:

   DISABLE [[NO]VALIDATE] [UNIQUE] column options
   DISABLE [[NO]VALIDATE] PRIMARY KEY options
   DISABLE [[NO]VALIDATE] [UNIQUE] CONSTRAINT constraint_name options
   DISABLE 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
drop constraint - clause
enable - Enable a constraint

Related Views:

 DBA_CONSTRAINTS      ALL_CONSTRAINTS      USER_CONSTRAINTS 
 DBA_CONS_COLUMNS     ALL_CONS_COLUMNS     USER_CONS_COLUMNS