SQL Script Disable all database triggers

Updated : 1-June-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

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

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal