THanks for the all the replies and explanation. I was more hung up on number of rows that are deleted rather than the process of deletion. Thanks again for the explanation. -Deen On Wed, Oct 28, 2009 at 12:12 PM, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> wrote: > > 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 > > > > > > > > > -- //www.freelists.org/webpage/oracle-l