Re: set a rollback segment for a specific user

He said he was "accessing through an application", but never said if it was his application or not.

Sorry for confusion I might have created and thanks to you and Sybrand for explaining the cross-posting phenomenon to me

Regs
AK

Niall Litchfield wrote:

> "Karen" <abvk_at_ureach.com> wrote in message
> news:3D42319E.10101ED1_at_ureach.com...
> > If I understand well, all this is to assign a specific rollback segment to
> a
> > transaction?
>
> Unfortunately not. This is to ensure that a specific user account only gets
> to use one named rollback segment. The OP is aware of SET TRANSACTION USE
> ROLLBACK SEGMENT BLAH but can't use it (or the equivalents you suggest)
> because this is a packaged app.
>
> And cross posting means posting to more than one newsgroup in (vain) hope
> that you'll get a larger audience or more replies. All it actually does is
> waste bandwidth. Answering two questions (or more) in one post is fine so
> keep it up.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
Received on Sat Jul 27 2002 - 15:32:00 CDT