Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP Can't drop tables
> 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
It means that someone (or you, in another session) has the table locked. You will need to wait until the lock is released before you can drop the table. Received on Mon Mar 17 1997 - 00:00:00 CST