Re: transaction question

chuckh_at_dvol.com (Chuck Hamilton) wrote:
>If a statement fails due to the "rollback segment too small" error,
>won't that force the entire transaction to be rolled back?
>
>Assume I do the following....
>
>DELETE...
>INSERT...
>COMMIT;
>
>If the INSERT fails, won't that rollback the DELETE too? And then
>COMMIT an empty transaction?
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>This message delivered by electronic sled dogs. WOOF!

Chuck,

If the insert fails, it WILL NOT rollback the DELETE. Reason, the rollback segments contain information about the deleted data. Since the the next statement is an insert, the data in the rollback segment for the deleted data are still in the "ACTIVE STATE". Note that it is the INSERT that failed not the DELETE. So, when the COMMIT is issued the changes are made permanent for the DELETE.

BTW, I tested the above scenario.

Naren Chintala
naren_at_mink.att.com Received on Fri Sep 13 1996 - 00:00:00 CEST