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: Lock Doubt

Re: Lock Doubt

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 12 Jul 2000 09:05:59 GMT
Message-Id: <10556.111770@fatcity.com>


it's doing rollback.... wait and try again a bit later

>From: "H. KARTHIKEYAN" <h.karthikeyan_at_tatainfotech.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Lock Doubt
>Date: Tue, 11 Jul 2000 22:34:19 -0800
>
>Hi all
>
>I have issued a update statement against a table. The table is locked.
>I explicitly killed that session.
>I queried v$session , the status for that session was 'killed'
>And that particular object exists in v$lock. So, when i try to do
>something with the table, its giving 'resource busy'
>
>I couldnt figure out whats happening ?.
>
>TIA
>
>**************************************
>H.Karthikeyan
>Tata Infotech Ltd.,
>System Integration Division,
>80 Feet Road, Indira Nagar, Bangalore.
>Ph: (80) 528 4681 (off) Ext: 423
>E-mail: h.karthikeyan_at_tatainfotech.com
>**************************************
>
>--
>Author: H. KARTHIKEYAN
> INET: h.karthikeyan_at_tatainfotech.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Wed Jul 12 2000 - 04:05:59 CDT

Original text of this message

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