Disable all FK of DB

----------------------------------
---Disabling of FOREIGN KEYS-----
----------------------------------


BEGIN
FOR i IN (SELECT table_name, constraint_name, owner --disable first the foreign key
FROM user_constraints
WHERE --applica solo su Check constraint on a table, Referential integrity
table_name NOT LIKE 'BIN$%'
AND (constraint_type ='C' OR constraint_type ='R')
AND status = 'ENABLED'
)
LOOP
EXECUTE IMMEDIATE 'alter table ' ||i.owner|| '.' ||i.table_name|| ' disable constraint ' ||i.constraint_name;
END LOOP i;
END;
/