Re: set a rollback segment for a specific user

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 26 Jul 2002 08:01:11 -0700
Message-ID: <ahro7n01v0r@drn.newsguy.com>

In article <ahrlbh$vi73t$1_at_ID-82797.news.dfncis.de>, "Steven" says...
>
>Hi,
>
>I'm wondering if it is possible to set a specific rollback segment for a
>user so that user only uses the specified rollback segment. My problem is
>that sometimes I perform large transactions and want to use the large
>rollback segment. However, I cannot specify the rollback segment using "set
>transaction......" because I am accessing the data through an application.
>
>Any help will be appreciated,
>Regards,
>Steve.
>
>
>

Nope, Niall's approach is the only way that this will work. Even then, you're not guaranteed that other users won't use the same rollback segment.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Jul 26 2002 - 10:01:11 CDT