Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Lock Doubt

Lock Doubt

From: H. KARTHIKEYAN <h.karthikeyan_at_tatainfotech.com>
Date: Wed, 12 Jul 2000 10:58:50 +0530 (IST)
Message-Id: <10555.111756@fatcity.com>


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
Received on Wed Jul 12 2000 - 00:28:50 CDT

Original text of this message

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