set echo off
set heading off
set feedback off

PROMPT --------------------------------------------
PROMPT - Mise Hors ligne des segments de rollback -
PROMPT --------------------------------------------

set term off
spool rbs_hors_ligne.tmp

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

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

spool off
set term on

@rbs_hors_ligne.tmp
