SQL Script Disable All Database Triggers

Updated: 01-Jun-1998
Version: 1.0

Description

This script disables all database triggers. If you are supporting a database that uses triggers, you'll need this script if you ever attempt a database import. 

See also Enable triggers script.

Parameters

None

SQL Source

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

spool trigsoff.lst

set pages 0
set verify off

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

spool off

start trigsoff.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