Re: Specifying rollback segments for SQL*Loader

Paul,

Regards this issue please read the followup I send you & Donna.

I was not clear on the sequence, but you can assign a rollback segment to a session using the set command.

Thanks,

Vikram Goel.

Sr. DBA

paulb_at_pcnet.com (Paul Baumgartel) wrote:
>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.
>********************************************************************
>
>
>
Received on Fri Nov 03 1995 - 00:00:00 CET