Re: resource busy and acquire with NOWAIT specified

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 20 Mar 2000 22:15:36 +0800
Message-ID: <38D63288.5123@yahoo.com>

Maggie wrote:
>
> I updated table and inserted rows and commit. Then, I would like to
> truncate the table, but I got:
>
> SQL> TRUNCATE TABLE DR11_ORDERS_TMP;
> TRUNCATE TABLE DR11_ORDERS_TMP
> *
> ERROR at line 1:
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> ---------------------------
> I wait for a few minutes and even open a new session to try to truncate
> again but I still got same errors.
>
> How can unlock table ?

Some one is doing some mods to the table - have a look at V$SESSION and V$LOCK to see who is doing what...Kick them off and your truncate will work.

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Mon Mar 20 2000 - 08:15:36 CST