Re: set a rollback segment for a specific user

A rollback segment can be assigned by calling a procedure from a package.

I think it is DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT, although I can be mistaken.

You probably do not need to research how to assign a rbs to a user.

Regs
AK

Steven wrote:

> 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.
Received on Sat Jul 27 2002 - 00:08:56 CDT