hi all,
Thanx for the reply and help. But my question is I have a script wherein I
am specifying a particular RBS to be used and before the execution of the
script the RBS is dropped. No doubt I will get the error saying that the
specified rollback segment does not exist( which I received this morning)
and the rest of the command were executed successfully. Which RBS was used
for the transaction(was it SYSTEM) how to check this. My colleague says it
wont use SYSTEM in any condition but other RBS will be used. Is it true? Why
SYSTEM rbs can not be used in any situation if he is right. and in what
conditions this SYSTEM rbs is used?
On 6/23/05, Sunil Bhola <oraclebhola_at_yahoo.com> wrote:
>
> 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
>
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 23 2005 - 09:02:02 CDT
