alter table table_name disable/enable constraint constraint_name;
declare
select 'ALTER TABLE ' || owner || '.' || table_name || ' disable constraint ' || constraint_name as stmt
from dba_constraints
where constraint_type = 'R'
;
begin
for r in fks loop
execute immediate r.stmt;
end loop;
end;