REM 
REM
REM Enable all non-SYS Primary Key, Unique, and Foreign Key constraints for a
REM database.
REM
REM Created by 09/31/02 by Ed Campbell
REM
SET linesize 132
SET pagesize 0
SET heading off
SET verify off
SET echo off
SET feedback off
SET termout off
SPOOL enbconxx.sql
PROMPT spool enbcon.lis
SELECT    'ALTER TABLE '|| owner|| '.'|| table_name|| CHR (10)
       || '  ENABLE CONSTRAINT '|| constraint_name|| ';'
  FROM dba_constraints
 WHERE constraint_type = 'R'
   and status = 'DISABLED' 
   AND table_name IN (SELECT table_name
                        FROM dba_tables
                       WHERE owner != 'SYS' AND owner != 'SYSTEM');
SELECT 'ALTER TABLE '|| owner|| '.'|| table_name
       || CHR (10)|| '  ENABLE CONSTRAINT '|| constraint_name|| ';'
  FROM dba_constraints
 WHERE constraint_type IN ('P', 'U')
   and status = 'DISABLED' 
   AND table_name IN (SELECT table_name
                        FROM dba_tables
                       WHERE owner != 'SYS' AND owner != 'SYSTEM');
PROMPT spool off
SPOOL off
@enbconxx.sql
PROMPT Check discon.lis log file for any errors