Cannot truncate table because of a BUSY/NOWAIT error message
Posted on 2007-10-19
I am struggling with this message:
ORA-00054 ressource busy and acquire with nowait specified.
when I try to "truncate" a table.
I've read a couple of previous answered questions and they don't seem to help me.
For example this query returns 0 records.
from v$access a,v$session b
where object='my table' and a.sid=b.sid;
I am pretty much alone working with this database since it is a new server not in production. I am also learning the Oracle architecture so I am currently not at ease on how to solve this.
The context is that I was writing a new procedure with PL/SQL Developer,
and using another window to launch it.
Worked a few times but now it breaks at this line:
execute immediate ('truncate table mytable');
Any DDL issued on this table generates the error.
This situation has come up before, and I usually get out of it by issuing a few "commit;" statement, but this time it doesn't work,
any help will be appreciated,