--禁用外键
declare
v_sql varchar2(2000);
CURSOR c_con IS SELECT 'alter table '||owner||'.'||table_name||' disable constraint
'||constraint_name from dba_constraints where constraint_type='R' and owner in
('JC2015YC');
BEGIN
OPEN c_con;
LOOP
FETCH c_con INTO v_sql;
EXIT WHEN c_con%NOTFOUND;
execute immediate v_sql;
end loop;
close c_con;
end;
/
--确认外键已经被禁用
select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS
from dba_CONSTRAINTS
where CONSTRAINT_TYPE='R' and status = 'ENABLED' and owner in ('JC2015YC');