Re: Problems deleting from table and deleting table

phj_at_remus.rutgers.edu (P. Ju) wrote:

>I have a table named article which references itself and another table.
>I'm trying to delete from it... it used to work but now it sits staring
>at me. Some error reports suggest I might be having a deadlock problem
>but I can't figure out what's going on.
 

>Can anyone help ?

>Patricia
>phj_at_pilot.njin.net

>--- errors follow ---

>SQL> truncate table article;
>truncate table article
> *
>ERROR at line 1:
>ORA-00054: resource busy and acquire with NOWAIT specified

>SQL> drop table article;
>drop table article
> *
>ERROR at line 1:
>ORA-00054: resource busy and acquire with NOWAIT specified

Someone has a transaction pending or has placed a lock on the table. They need to rollback or commit.

Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers" jared_at_valleynet.com Received on Mon Nov 20 1995 - 00:00:00 CET