Specifying rollback segments for SQL*Loader

On Friday, October 27, vgoel_at_pts.mot.com wrote:

>Another way is to follow these steps:
>
>1) Create a private rollback segment (u_segment) for the user executing load,
>in
>the tablespace where the current large rollback segment exits. Do not bring it
> on line.
>2) From a shell startup sqlplus follow these sub-steps:

[snip]

>NOTE: This works as the 'u_segment' can only be used by this user.

[snip]

There is no way to create a rollback segment for exclusive use by a given

user. A "private" rollback segment means a segment usable only by the instance that specifies it for acquisition at startup, as opposed to a "public" segment that can be used by any of multiple instances that access the same database (when running Parallel Server).

Once you bring a private RBS online, it's available for any transaction. In your example, if there are any RBS's other than "u_segment" and SYSTEM online at the time the load starts, there is NO guarantee that the load will use "u_segment", because transactions are assigned to online RBS's in a round-robin fashion.

Paul Baumgartel, Principal Consultant              paulb_at_pcnet.com 
Adept Computer Associates, Inc.                                    
********************************************************************