Re: ORA-00054: resource busy and acquire with NOWAIT specified
From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 29 Oct 2009 00:12:32 +0800
Message-Id: <200910281612.n9SGCecR023997_at_smtp17.singnet.com.sg>
Date: Thu, 29 Oct 2009 00:12:32 +0800
Message-Id: <200910281612.n9SGCecR023997_at_smtp17.singnet.com.sg>
The transaction is "defined" when the DML starts. It doesn't matter if it ends up deleting 1million rows or 0rows. It is still a transaction holding a Transaction Lock. This prevents DDL on the table.
Hemant K Chitale
At 05:09 AM Wednesday, you wrote:
>Hello gurus,
>
>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 Wed Oct 28 2009 - 11:12:32 CDT