If I recall correctly, a deadlock gives an ora-60 error in the alert log and kills one of the two sessions (which one has always been a mistery to me, the doc says it's the one that initiates the deadlock... but since deadlock is essentialy a circular block, this makes little sense). Now, when Oracle kills a session, the ENTIRE transaction is rolled back. hth Alan Bort Oracle Certified Professional