set echo off
set head off
set feed off

PROMPT -------------------------------------------------
PROMPT - Desactivation de tous les triggers de la base -
PROMPT -------------------------------------------------

spool triggers_hors_ligne.tmp

SELECT 
   'alter trigger '||owner||'.'||trigger_name||' disable;'
FROM 
   all_triggers
WHERE 
   owner not in ('SYS','SYSTEM')
AND 
   status = 'ENABLED';

spool off
set feed on
set echo on
@triggers_hors_ligne.tmp
