Re: set a rollback segment for a specific user

From: Epicentre team A <oracle_at_epicentre.fr>
Date: Fri, 26 Jul 2002 16:24:38 +0200
Message-ID: <ahrlrr$k6h$1@wanadoo.fr>

Hi

Yes you can assign a rollback segment to specific transaction. SET TRANSACTION USE ROLLBACK SEGMENT nom du segment.

---

---

Très cordialement

Denis Jeanneret - Directeur Technique, Division ORACLE
----------------------------------------------------------------------------
------------------------------

"Steven" <steven.pannell_at_gmx.net> wrote in message news:ahrlbh$vi73t$1_at_ID-82797.news.dfncis.de...
> 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 Fri Jul 26 2002 - 09:24:38 CDT