Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00054
ORA-00054 [message #191231] Tue, 05 September 2006 05:09 Go to next message
stuppaz
Messages: 4
Registered: September 2006
Location: italy
Junior Member

Hi, I'm new in this forum. I read something about this error but I don't understand how to solve my problem.

I want to delete a record in a table but I caught the error ORA-00054.

I went to see in the user_objects and v$locked_object, there are two row for the table where i want to delete the row... How to unloock this situation ?

Thanks
Re: ORA-00054 [message #191232 is a reply to message #191231] Tue, 05 September 2006 05:16 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,



this should help you.

http://www.orafaq.com/forum/t/65359/0/


regards,
Re: ORA-00054 [message #191234 is a reply to message #191232] Tue, 05 September 2006 05:25 Go to previous messageGo to next message
stuppaz
Messages: 4
Registered: September 2006
Location: italy
Junior Member

I was very very deficient regard my question ...
It was normal to see and kill the process to come back at the normality...

Thanks
Re: ORA-00054 [message #191235 is a reply to message #191231] Tue, 05 September 2006 05:25 Go to previous message
stuppaz
Messages: 4
Registered: September 2006
Location: italy
Junior Member

I thought something more complicate !!! Embarassed
Previous Topic: Problem in executing a procedure
Next Topic: How To Extract Conditional Data From Oracle Table To Binary File.
Goto Forum:
  


Current Time: Wed Dec 07 03:15:44 CST 2016

Total time taken to generate the page: 0.17102 seconds