Re: RBS problem...

  • From: Sunil Bhola <oraclebhola@xxxxxxxxx>
  • To: onkarnath.tiwary@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 23 Jun 2005 05:40:49 -0700 (PDT)

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@xxxxxxxxx> 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@xxxxxxxxx
       onkarnath.tiwary@xxxxxxxxx
 


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 

Other related posts: