Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to delete a lock
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
![]() |
![]() |