oracle禁启用外键和触发器

-----启用外键和触发器--

BEGIN
for c in (select 'ALTER TABLE '||TABLE_NAME||' ENABLE CONSTRAINT '||constraint_name||' ' as v_sql from user_constraints where CONSTRAINT_TYPE='R')
loop
begin
 EXECUTE IMMEDIATE c.v_sql;

 end;
end loop;
for c in (select 'ALTER TABLE '||TNAME||' ENABLE ALL TRIGGERS ' AS v_sql from tab where tabtype='TABLE') loop

 begin
 execute immediate c.v_sql;

 end;
end loop;
end;

 

 

--禁用外键和触发器----

BEGIN
for c in (select 'ALTER TABLE '||TABLE_NAME||' DISABLE CONSTRAINT '||constraint_name||' ' as v_sql from user_constraints where CONSTRAINT_TYPE='R') loop

begin
 EXECUTE IMMEDIATE c.v_sql;

 end;
end loop;
for c in (select 'ALTER TABLE '||TNAME||' DISABLE ALL TRIGGERS ' AS v_sql from tab where tabtype='TABLE') loop

 begin
 execute immediate c.v_sql;

 end;
end loop;
end;