ORA-00054: resource busy and acquire with NOWAIT specified
From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Tue, 27 Oct 2009 17:09:38 -0400
Message-ID: <1c8f76b90910271409p1dd30832ma7f8342416091ed8_at_mail.gmail.com>
Hello gurus,
Date: Tue, 27 Oct 2009 17:09:38 -0400
Message-ID: <1c8f76b90910271409p1dd30832ma7f8342416091ed8_at_mail.gmail.com>
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-lReceived on Tue Oct 27 2009 - 16:09:38 CDT