CREATE SCRIPT TO DISABLE AND ENABLE CONSTRAINT

DISABLE

SELECT 'ALTER TABLE "' || A.TABLE_NAME || '" DISABLE CONSTRAINT "' || A.CONSTRAINT_NAME || '";' ENABLE_CONSTRAINTS
FROM   USER_CONSTRAINTS A
WHERE  
       A.CONSTRAINT_TYPE = 'R' 
AND    A.R_CONSTRAINT_NAME IN (SELECT A1.CONSTRAINT_NAME
                               FROM   USER_CONSTRAINTS A1
                               WHERE  A1.TABLE_NAME = DECODE(UPPER('&1'),'ALL',A.TABLE_NAME,UPPER('&1'))
                               );

ENABLE

SELECT 'ALTER TABLE "' || A.TABLE_NAME || '" ENABLE CONSTRAINT "' || A.CONSTRAINT_NAME || '";'
FROM   USER_CONSTRAINTS A
WHERE  A.CONSTRAINT_TYPE = 'R'
AND    A.TABLE_NAME      = DECODE(UPPER('&1'),'ALL',A.TABLE_NAME,UPPER('&1'))
AND    A.STATUS          = 'DISABLED';