ORA-00054: resource busy and acquire with NOWAIT specified

Hello gurus,

I got this error and I want to confirm my concepts are right.

Session 1

delete from tab1 where col1=20;
0 rows deleted

session2
truncate table tab1;
I get "ORA-00054: resource busy and acquire with NOWAIT specified"


When session1 deleted 0 records, it should not be placing any locks on
the table correct? I do not understand why I got the error. Am I
missing some basic concept?

When I did a rollback on the session1 then session2 was able to
truncate the table.


Thanks
Deen
--
http://www.freelists.org/webpage/oracle-l


Other related posts: