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

Home -> Community -> Usenet -> c.d.o.misc -> How to delete a lock

How to delete a lock

From: <dn.perl_at_gmail.com>
Date: 7 Aug 2006 16:51:52 -0700
Message-ID: <1154994712.576260.177940@p79g2000cwp.googlegroups.com>

A table has been locked and I want to free it. I have looked at v$lock and v$session objects, but I don't know what entry to delete from where. What I do know is that nobody is using the database right now, and it is okay for me to delete the appropraite entry (whether from v$lock or v$session). Out of the first 5-10 links which turn up in a google or google-groups search for "delete lock oracle", no link provides a quick route to delete a lock and free the locked object.

Please advise. Received on Mon Aug 07 2006 - 18:51:52 CDT

Original text of this message

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