Re: SQL connundrum. Can it be done?

danielroy10junk_at_hotmail.com (Daniel Roy) wrote

> I understand your concerns for the data integrity, but I always commit
> just at the end of the block, when it's possible. That way, Oracle
> takes care of the integrity of the data (changes are applied for all
> or no records at all). Plus these programs are meant to be run when
> there's no one else on the system anyway (we are lucky enough to not
> have a 24/7 database). These tasks are kept for the week-end, when no
> one else is around.

I thought as much - but at the same time the OP needs to know what dangers lurk beneath transaction "chunk" processing when one changes a transaction from an all-or-nothing event to a partial-maybe event.

--
Billy