RE: RBS problem...

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 23 Jun 2005 09:02:58 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E73D@EXCNYSM0A1AJ.nysemail.nyenet>

The system RBS is reserved and probably would not be used by your process.

But the bug question is if your transaction worked properly, why are you trying to use a specific rollback segment? Hard coding transactions to use a specific resource is a bad habit to get into. And when you move to Undo tablespaces, rollback segment selection is not longer available.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary Sent: Thursday, June 23, 2005 8:57 AM
To: Sunil Bhola
Cc: oracle-l_at_freelists.org
Subject: Re: RBS problem...

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/ <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://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:08:32 CDT