Problems deleting from table and deleting table

From: P. Ju <phj_at_remus.rutgers.edu>
Date: 1995/11/14
Message-ID: <48aouq$df4_at_remus.rutgers.edu>#1/1


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 Received on Tue Nov 14 1995 - 00:00:00 CET

Original text of this message