DISABLED CONSTRAINT NOTES

 

Disabled Constraints

DISABLED CONSTRAINT NOTES:

Owner - Owner of the table

Table Name - Name of the table

Constraint Name - Name of the constraint

Constraint Type - Type of constraint

Status - Current status of the constraint

select  OWNER,
        TABLE_NAME,
        CONSTRAINT_NAME,
        decode(CONSTRAINT_TYPE, 'C','Check',
                                'P','Primary Key',
                                'U','Unique',
                                'R','Foreign Key',
                                'V','With Check Option') type,
        STATUS 
from  dba_constraints
where  STATUS = 'DISABLED'
order  by OWNER, TABLE_NAME, CONSTRAINT_NAME