RE: RBS problem...
- From: "Yasin Baskan" <yasbs@xxxxxxxxxxxxxx>
- To: <onkarnath.tiwary@xxxxxxxxx>, "Sunil Bhola" <oraclebhola@xxxxxxxxx>
- Date: Thu, 23 Jun 2005 16:11:59 +0300
You can find many notes about rollback segments in Metalink.
Note:62005.1 says that :
"The system rollback segment can only be used for transactions that occur on
objects inside the system tablespace. This is done because the main purpose of
the system rollback segment is to handle rollback for DDL transactions - that
is transactions against the data dictionary tables themselves. "
Your script uses one of the other online rollback segments. You can find which
one is being used by querying v$transaction.
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Onkar N Tiwary
Sent: Thursday, June 23, 2005 3:57 PM
To: Sunil Bhola
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@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
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel ve
Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu mesaj,
hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para
karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten sorumlu
kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz, yayinlamayiniz,
baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi derhal uyararak bu
mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer alan bilgilerin
dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan garanti edilmemektedir
ve bilinen viruslere karsi kontrolleri yapilmis olarak yollanan mesajin
sisteminizde yaratabilecegi zararlardan Bankamiz sorumlu tutulamaz.
This message and the files attached to it are under the privacy liability in
accordance with the Banking Law and confidential to the use of the individual
or entity to whom they are addressed. This message cannot be copied, disclosed
or sold monetary consideration for any purpose. If you are not the intended
recipient of this message, you should not copy, distribute, disclose or forward
the information that exists in the content and in the attachments of this
message; please notify the sender immediately and delete all copies of this
message. Our Bank does not warrant the accuracy, integrity and currency of the
information transmitted with this message. This message has been detected for
all known computer viruses thence our Bank is not liable for the occurrence of
any system corruption caused by this message
--
//www.freelists.org/webpage/oracle-l
Other related posts:
