Re: Problems with Rollback Segments for Oracle Version 6

>I am quite puzzled by the way that Oracle distributes transactions across
>rollback segments. In my INIT.ORA, I acquired the following rollback
>segments during startup:
>
>RollBack Segment TableSpace MaxExtents FileID
>---------------- ---------- ---------- ------
>SYSTEM_RS SYSTEM 30 1
>USER_RS1 USER_ROLLBACK 50 2
>USER_RS2 USER_ROLLBACK 50 3
>
>finished OK. Can somebody explain to me why the first DML always failed
>to distribute transactions to the fallback segments (e.g., USER_RS1/RS2),

I am pretty sure Oracle randomly selects Rollback segments. Therefore, if other people were doing work (or not doing work), maybe the first import was only using the first RBS, and then when you did the 2nd import, it used all 3. I had similar problems and just made one big (50Mb) RBS.

-- 
----------------------------------------------------------------------
*  The first thing we do let's kill all the lawyers    _Shakespeare  *
----------------------------------------------------------------------