Re: resource busy and acquire with NOWAIT specified

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 Mar 2000 21:29:55 +0100
Message-ID: <953584240.19223.1.pluto.d4ee154e@news.demon.nl>

You will only get this if there is some other session using this table. You can't resolve the problem without kicking the other session out. Truncate requires an exclusive DDL lock. Check v$access for tables in use.

Hth,

Sybrand Bakker, Oracle DBA

Maggie <maggiezhou_at_hotmail.com> wrote in message news:8b60j9$lpo$1_at_web1.cup.hp.com...
> 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 ?
>
>
Received on Mon Mar 20 2000 - 14:29:55 CST