ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

oracle ora-00054
sun picture sun · Jan 30, 2011 · Viewed 1.1M times · Source

Why am I getting this database error when I update a table?

ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Answer

user258367 picture user258367 · Jan 30, 2011

Your table is already locked by some query. For example, you may have executed "select for update" and have not yet committed/rollbacked and fired another select query. Do a commit/rollback before executing your query.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More