禁用启用所有外键约束.tst

最新推荐文章于 2019-03-23 09:52:29 发布

vernonchen163

最新推荐文章于 2019-03-23 09:52:29 发布

阅读量170

点赞数

分类专栏： oracle 数据库文章标签： java

本文链接：https://blog.csdn.net/vernonchen163/article/details/84695575

版权

数据库同时被 2 个专栏收录

45 篇文章 0 订阅

订阅专栏

oracle

39 篇文章 0 订阅

订阅专栏

禁用所有外键约束.tst
declare
cursor c1 is
select t.table_name
,t.constraint_name
from user_constraints t
where t.owner = 'EMS3'
AND T.constraint_type = 'R';
stmt varchar2(4000);
begin
for cc in c1 loop
BEGIN

stmt := 'alter table ' || cc.table_name || ' disable constraint ' ||
cc.constraint_name;
dbms_output.put_line(stmt);
execute immediate stmt;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('error ' || stmt);
end;
end loop;
end;

启用所有外键约束.tst
declare
cursor c1 is
select t.table_name
,t.constraint_name
from user_constraints t
where t.owner = 'EMS3'
AND T.constraint_type = 'R';
stmt varchar2(4000);
begin
for cc in c1 loop
BEGIN

stmt := 'alter table ' || cc.table_name || ' enable constraint ' ||
cc.constraint_name;
dbms_output.put_line(stmt);
execute immediate stmt;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('error ' || stmt);
end;
end loop;
end;