oracle事物显示启用约束,sql – 启用oracle约束的问题

我正在尝试几天来禁用所有表的约束,插入数据并启用约束.它工作但我做了一些测试,当我插入一个不尊重外键的行时,启用约束时没有错误消息.我只能看到该约束未经验证.

这是要禁用的代码

begin

BEGIN

FOR rec IN ( SELECT constraint_name, table_name FROM user_constraints WHERE constraint_type = 'R' OR constraint_type = 'P' )

LOOP

BEGIN

EXECUTE IMMEDIATE 'alter table '||rec.table_name||' disable constraint '||rec.constraint_name;

EXCEPTION WHEN OTHERS THEN

dbms_output.put_line( 'ERROR: alter table '||rec.table_name||' DISABLE constraint '||rec.constraint_name||';' );

END;

END LOOP;

DBMS_OUTPUT.PUT_LINE('CONSTRAINTS DISABLED');

END;

BEGIN

FOR rec IN ( SELECT trigger_name FROM user_triggers WHERE TRIGGER_NAME NOT LIKE 'BIN$%' )

LOOP

EXECUTE IMMEDIATE 'alter trigger '||rec.trigger_name||' disable';

END LOOP;

END;

DBMS_OUTPUT.PUT_LINE('TRIGGERS DISABLED');

end;

/

这是要启用的代码

begin

BEGIN

FOR rec IN ( SELECT constraint_name, table_name FROM user_constraints where status = 'DISABLED' and constraint_type = 'R' OR constraint_type = 'P' )

LOOP

BEGIN

EXECUTE IMMEDIATE 'alter table '||rec.table_name||' enable constraint '||rec.constraint_name;

dbms_output.put_line('alter table '||rec.table_name||' enable constraint '||rec.constraint_name);

EXCEPTION

WHEN OTHERS THEN

dbms_output.put_line('ERROR: alter table '||rec.table_name||' enable constraint '||rec.constraint_name||' ;' );

END;

END LOOP;

END;

DBMS_OUTPUT.PUT_LINE('CONSTRAINTS ENABLED');

BEGIN

FOR rec IN ( SELECT trigger_name FROM user_triggers WHERE TRIGGER_NAME NOT LIKE 'BIN$%' )

LOOP

EXECUTE IMMEDIATE 'alter trigger '||rec.trigger_name||' enable';

END LOOP;

END;

DBMS_OUTPUT.PUT_LINE('TRIGGERS ENABLED');

END;

我不知道如何在最后检查所有约束,如果不起作用则执行回滚.