SQL Script Enable All Database Triggers

Updated: 01-Jun-1998
Version: 1.0

Description

This script enable all database triggers. If you are supporting a database that uses triggers, you'll need this script after a database import. See also Disable Triggers script.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

spool trigson.lst

set pages 0
set verify off

select 'ALTER TRIGGER '||owner||'.'||trigger_name||' ENABLE;'
from dba_triggers
/

spool off

start trigson.lst

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links