rem 
rem
rem Disables all non-SYS and Triggers in a
rem database.
rem
rem Last Change 07/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 distrgxx.sql
prompt spool distrg.lis
select  'ALTER TRIGGER '||TRIGGER_NAME||' DISABLE; '
 from dba_triggers
where status = 'ENABLED' 
  and table_name in (select table_name 
                       from dba_tables 
                      where owner != 'SYS');
prompt spool off
spool off
@distrgxx.sql
prompt Check discon.lis log file for any errors