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