Re: HELP Can't drop tables

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.su