Re: Interesting Oracle Data Load Scenario

>
> Even simpler.
> commit;
> do all data load stuff
> if it works then
> commit;
>
> else
> rollback;
>
> If the system goes down in the middle of the load then when it comes back up
> it will rollback the changes. This is exactly what Oracle is good at and
> you don't need to make things complicated.
> Jim

You are right.. When I posted the original question, in the back of my mind I knew it was a "slegehammer to crack a nut" idea. But I just wanted to bounce some ideas off people in the group.

I will explain to the data conversion team that the important thing is to build in proper transaction control (i.e. commit/rollback).

Thanks for you help and time.

Cheers

Matt Received on Mon May 24 2004 - 02:46:07 CDT