Home » SQL & PL/SQL » SQL & PL/SQL » IMP-00017: following statement failed with ORACLE error 54:
IMP-00017: following statement failed with ORACLE error 54: [message #37548] Wed, 13 February 2002 20:41 Go to next message
aks
Messages: 8
Registered: February 2002
Junior Member
What is the Solution for this Problem?

ORA-00054: resource busy and acquire with NOWAIT specified
Re: IMP-00017: following statement failed with ORACLE error 54: [message #37549 is a reply to message #37548] Wed, 13 February 2002 21:04 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
ORA-00054: resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.

Action: Try the command after a few minutes or enter the command without the NOWAIT keyword.
Previous Topic: Scrollable Resultset
Next Topic: Improve Performance of SQL
Goto Forum:
  


Current Time: Tue Apr 23 09:27:38 CDT 2024