Disabling Constraints

[netbar]

Hi,

What is the bets way to disable all fk's and triggers within a given schema!

Cheers

[jovery]

Spool the output from this script and run it against your schema to disable the constraints

SELECT 
  'ALTER TABLE '|| table_name 
  || ' DISABLE CONSTRAINT ' || constraint_name || ' ;'
FROM user_constraints
WHERE constraint_type = 'R'

To disable the triggers

SELECT
  'ALTER TRIGGER '||trigger_name||' DISABLE;'
FROM user_triggers

HTH

[netbar]

Thanks