Disable all foreign constraints...

[omacron]

I need to be able to disable foreign constraints on all tables. Is there a script to do that? Also I will need to enable after words.

 

[Thargy]

Yes,

within the relevant schema run the following anonymous block

BEGIN

FOR X IN
(
SELECT TABLE_NAME, CONSTRAINT_NAME
  FROM USER_CONSTRAINTS
 WHERE CONSTRAINT_TYPE = 'R'
 ORDER BY TABLE_NAME
)
LOOP
    EXECUTE IMMEDIATE 'ALTER TABLE '||X.TABLE_NAME||' DISABLE CONSTRAINT '||X.CONSTRAINT_NAME;
END LOOP;

END;

To enable afterwards, edit the word DISABLE to ENABLE.

Regards

T