OraFAQ Forum: General » unlock rows in oracle table

Home » Other » General » unlock rows in oracle table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unlock rows in oracle table [message #102036]

Sun, 20 January 2002 23:20

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

Report message to a moderator

Re: unlock rows in oracle table [message #102046 is a reply to message #102036]

Wed, 23 January 2002 09:14

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.

Report message to a moderator

unlock rows in oracle [message #102532 is a reply to message #102036]

Thu, 11 July 2002 02:43

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,

Report message to a moderator

Re: unlock rows in oracle table [message #102582 is a reply to message #102036]

Thu, 25 July 2002 16:02

Mahesh
Messages: 90
Registered: January 2001

Member

Where is link ???

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 11:28:16 CST 2024