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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RBS problem...

Re: RBS problem...

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Thu, 23 Jun 2005 05:40:49 -0700 (PDT)
Message-ID: <20050623124049.75833.qmail@web31603.mail.mud.yahoo.com>


Hi Onkar,  

When you assigned a particular rollback segment to the transaction which is actually deleted, Oracle will use the default rollback segment.  

To assign a rollback segment to a particular transation use either:-  

DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT(NAME) OR
DBMS_STANDARD.SET_ROLL_SEGS(NAME)   Regards,
Sunil Bhola

Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote: hi all,  

What will happen if i have assigned a particular rollback segment to a transactio but actually the RBS has been deleted????

--

Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)

       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com
 


QUERIES in Oracle, Feel free to Join:  

http://groups.yahoo.com/group/oracle_expert/  

Regards,
Sunil Bhola
Oracle_Expert, Moderator



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 23 2005 - 08:46:13 CDT

Original text of this message

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