set echo off
set heading off
set feedback off

PROMPT --------------------------------------------
PROMPT - Remise en ligne des segments de rollback -
PROMPT --------------------------------------------


set term off
spool rbs_en_ligne.tmp

SELECT 'set echo on' FROM dual;
SELECT 'set feedback on' FROM dual;

SELECT 
   'alter rollback segment '||segment_name||' online;'
FROM 
   dba_rollback_segs
WHERE 
   segment_name != 'SYSTEM'
AND 
   status = 'OFFLINE';

spool off
set term on

@rbs_en_ligne.tmp
