Home » Other » General » unlock rows in oracle table
unlock rows in oracle table [message #102036] Sun, 20 January 2002 23:20 Go to next message
Aniruddha Deshpande
Messages: 1
Registered: January 2002
Junior Member
Hello there!
I am having a servlet which is using update statement for a oracle table,somehow the oracle table row has got locked and I am not being able to modify the values, the error given is" resource busy and acquire with NOWAIT specified"
How do I unlock the table? pl. help
Re: unlock rows in oracle table [message #102046 is a reply to message #102036] Wed, 23 January 2002 09:14 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Someone else has the record locked. Connect as SYS and select from DBA_LOCKS, DBA_BLOCKERS, and DBA_WAITERS to determine who it is. Then either ask them to disconnect or kill their process. See the attached link on help to find locks and how to kill processes.
unlock rows in oracle [message #102532 is a reply to message #102036] Thu, 11 July 2002 02:43 Go to previous messageGo to next message
Pramod
Messages: 18
Registered: April 1999
Junior Member
Hello there!
I have problem which is using update statement for a oracle table,somehow the oracle table row has got locked and I am not being able to modify the values,
Re: unlock rows in oracle table [message #102582 is a reply to message #102036] Thu, 25 July 2002 16:02 Go to previous message
Mahesh
Messages: 90
Registered: January 2001
Member
Where is link ???
Previous Topic: how to get last months records on using any oracle functions
Next Topic: Re: where can I get newest Oracle Universal Installer
Goto Forum:
  


Current Time: Thu Mar 28 16:39:18 CDT 2024