Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00054 Error


Error:

ORA-00054: resource busy and acquire with NOWAIT specified

Cause:

You tried to execute a LOCK TABLE or SELECT FOR UPDATE command with the NOWAIT keyword but the resource was unavailable.

Action:

The options to resolve this Oracle error are:
  1. Wait and try the command again after a few minutes.
  2. Execute the command without the NOWAIT keyword.