set lines 150
set pages 0
set feedback off
spool rbsprod.lst;
select 'alter rollback segment '||segment_name||' offline;'
from dba_segments where (tablespace_name like '%ROLLBACK%'
or tablespace_name like '%RBS%') and bytes/1024/1024>.0300 and segment_name not like '%BIG%' order by segment_name;
select 'drop rollback segment '||segment_name||';'
from dba_segments where (tablespace_name like '%ROLLBACK%'
or tablespace_name like '%RBS%') and bytes/1024/1024>.0300 and segment_name not like '%BIG%'  order by segment_name;
select 'create rollback segment '||segment_name||
' storage (initial '||initial_extent||' next '||next_extent||' maxextents '||max_extents||' minextents '
||min_extents||') tablespace '||tablespace_name||';'
from dba_segments where (tablespace_name like '%ROLLBACK%'
or tablespace_name like '%RBS%') and bytes/1024/1024>.0300 and segment_name not like '%BIG%'  order by segment_name;
select 'alter rollback segment '||segment_name||' online;'
from dba_segments where (tablespace_name like '%ROLLBACK%'
or tablespace_name like '%RBS%') and bytes/1024/1024>.0300 and segment_name not like '%BIG%'  order by segment_name;
spool off;
set pages 50
set wrap off
set lines 100
set feedback on