Unlocking a table.

From: Anindya, Roy (GEAE, Foreign National) <Roy.Anindya_at_ae.ge.com>
Date: Fri, 12 Jan 2001 15:53:15 -0500
Message-Id: <10739.126563@fatcity.com>

Hi Gurus,
Is there any other way of unlocking an oracle table apart from "Alter system Kill session....."

I have tried the above command and got back the message saying that the session has been killed,but V$Lock and V$Locked_Object still shows the same Sid locking a particular table.Now the Alter system command gives a response as "session does not exist"

Any ideas?? can't shut down the database now,but need to free this table for insert and updates. The lock mode is 3 (row)

thanks in advance,
Anindya.

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). Received on Fri Jan 12 2001 - 14:53:15 CST