ORA-00054. How to unlock?

[biot023]

Hallo.
I'm afraid I know very little about Oracle - I'm not even sure if this is the right forum to post this question in - if not, could somebody point me in the right direction?
Anyway - I need to remove a lock from a table in an oracle database.
I cannot alter certain records, and when I try to truncate the table, I get this message:
"ORA-00054: resource busy and acquire with NOWAIT specified"

I think this may have occurred when a sql script hung, but cannot be sure as I was offsite.
If anyone could shed any light, I'd be incredibly grateful.
Thankyou,
Douglas JL

Common sense is what tells you the world is flat.

 

[LordZex]

I had this same problem. I solved it by connecting to the database as the user who obtained the lock, and running:

commit;

That released the lock, and my database is back. Yay!

Ryan Shillington

 

[sem]

I really doubt it's possible. The lock is obtained by session, not by user, thus you couldn't connect as the user and then commit; another session. Or at least using of "connecting to the database as the user" in inappropriate

Regards, Dima

http://seminihin.narod.ru