Re: HELP Can't drop tables
From: Alexey E. Neckrasow <nec_at_leaves.spb.su>
Date: 1997/03/18
Message-ID: <332E8C3B.5DE8_at_leaves.spb.su>#1/1
Date: 1997/03/18
Message-ID: <332E8C3B.5DE8_at_leaves.spb.su>#1/1
Hi!
The reason is that there is a transaction that've locked your table. Try to commit or rollback all transactions that have used the table.
john mancino wrote:
>
> What does this mean? I cant use it or drop it.
>
> SQL> drop table john_temp;
> drop table john_temp
> *
> ERROR at line 1:
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> John Mancino
>
> John.mancino_at_worldnet.att.net
-- Regards. Alexey Neckrasow. Leaves Inc. Russia. e-mail: nec_at_leaves.spb.suReceived on Tue Mar 18 1997 - 00:00:00 CET