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