Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> using a Rollback Segment for all transactions

using a Rollback Segment for all transactions

From: bertrand Quatromme <bertrand.quatromme_at_free.fr>
Date: Wed, 20 Nov 2002 19:27:01 +0100
Message-ID: <3ddbd3f5$0$18234$626a54ce@news.free.fr>

I work on a datawarehouse.
I have many transactions which works on multi-threaded sessions.

I try to have all my transaction use a rollback segment which is not always the default one.

Actually I have only found the following command :

        set transaction use rollback segment RBS_DSS;

But Can I do it at the session level ? or for the particular user which runs these transactions (at the time I create this user for example like when I choose the default tablespace) ?

Thanks for all help.

--
bertrand
Received on Wed Nov 20 2002 - 12:27:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US