Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP Can't drop tables
Hi there,
it could be in the middle of the long rollback. Saw it a numerous times.
WBW, Igor.
> Alexey E. Neckrasow wrote:
>
> 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
Received on Sun Mar 23 1997 - 00:00:00 CST