ORA-00054 Resource busy and acquire with NOWAIT specified

Cause: Resource interested is busy

Action: Retry if necessary

Explanation: This is a quite normal message and is reported if a SQL statement would have blocked waiting for another user to complete some operation.

The SQL command issued either:

a) had a 'NOWAIT' clause so instead of blocking the statement returns this error. or b) was DDL and was blocked. DDL or SELECT .. FOR UPDATE NOWAIT can raise this error if an incompatible lock is held.

Diagnosis: - None normally required unless this is occurring when not expected. - Check v$lock for locks being held. - For DDL repeat the command. If the DDL is issued under DBMS_SQL it is possible to cause this error if the DDL touches an object related to the current PL/SQL block by some dependency. - For SELECT FOR UPDATE issue the same statement without the NOWAIT clause to see if the statement blocks (assuming the problem is reproducible). If it blocks check there is a blocker in v$lock, select * from v$lock where request