gen_enable_triggers.sql

SET PAGES 0 TRIMS ON ECHO OFF VERIFY OFF FEEDBACK OFF


PROMPT
PROMPT ***** Enable All Triggers *****
PROMPT

SPOOL enable_triggers.sql

SELECT 'SET ECHO ON TIME ON' FROM dual;
SELECT 'SPOOL enable_triggers.log' FROM dual;
SELECT '' FROM dual;

SELECT 'ALTER TRIGGER ' || owner ||'.'|| trigger_name ||' ENABLE;'
FROM dba_triggers
WHERE table_owner=Upper('&1')
/

SELECT '' FROM dual;
SELECT 'SPOOL OFF' FROM dual;
SELECT 'SET ECHO OFF TIME OFF' FROM dual;

SPOOL OFF
SET PAGES 999 TRIMS ON ECHO OFF VERIFY ON FEEDBACK ON

PROMPT
PROMPT ********************************
PROMPT
PROMPT Output saved at enable_triggers.sql
PROMPT