Re: Alter rollback segments

Patrik wrote:

> Hi,
>
> I want to add "alter rollback segments" and "set transaction use
> rollback..."
> in my otherwise functioning procedure. I have to control which
> rollbackseg that the proc uses when it updates due to very large
> transactions.

Why?

Every bit of 'good' advice from Tom Kyte and other experts indicates that this is a bad idea. Just resize your rollback segments appropriately.

And if you have 9i ... you shouldn't be using rollback segments at all.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)