Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Enable/ disable constraints on a table

Generate the statements needed to enable a specific constraint type on a specific table:

SELECT 'alter table '  || table_name || ' ENABLE constraint '  || constraint_name || ';'  statements
FROM dba_constraints
WHERE owner = 'SCOTT'

      AND constraint_type = 'C'

      AND table_name = 'EMP';

Generate the statements needed to disable a specific constraint type on a specific table:

SELECT 'alter table '  || table_name || ' DISABLE constraint '  || constraint_name || ';'  statements
FROM dba_constraints
WHERE owner = 'SCOTT'

      AND constraint_type = 'C'

      AND table_name = 'EMP';