set echo off
set head off
set feed off

PROMPT -------------------------------------------------
PROMPT - Re-activation de tous les triggers de la base -
PROMPT -------------------------------------------------

spool triggers_en_ligne.tmp

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

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