Blog

14 Aug 2012

Getting around ORA-00054 in Oracle 10g

In 10g, if you are trying to make DDL changes on a busy object, you’re met with:

ORA-00054: resource busy and acquire with NOWAIT specified

If you google how to fix this, your told to re-run the transaction, or find out what’s locking the object. If your trying to make schema changes on a live system in a scripted/automated way, you dont want to interfere with production processes and you need to deal with re-running the transaction in an automated way. This is the solution.

Get a quote in 24h

Wether a huge commerce system, or a small business website, we will quote the project within 24h of you pressing the following button: Get quote