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