No need to remove. Just get your DBA to take the RBS offline.
ALTER ROLLBACK SEGMENT rbs_name OFFLINE;
When you are done, put the RBS online.
ALTER ROLLBACK SEGMENT rbs_name ONLINE;
You will need to do this for all rollback segments that you would normally be using. Do not take the system RBS offline. To get the status of all RBS:
SELECT segment_name, tablespace_name, status FROM sys.dba_rollback_segs;
>Is there possible to remove all rollback segments ? I need to delete bunch of rows (I cannot truncate the tables since there is a criteria for the deletes) from tables in order to re-load them aftrewards. I am doing ETL work, not OLTP. I do not need rollback segments. When I try to delete 500k-1M rows, I get out of rollback segments. But I want to delete these rows anyway, I will not issue a rollback afterwards. My dba cannot allocate me more space for rbs. So I create a small PL/SQL stored procedure that delete and commit at each 250K rows. But, since it uses rbs, it takes long time to execute.
>
>Can somebody help me on this ?
>
>Thank you,
>Christian
Mark McCasland
Midlothian, TX USA