>>>Then, what would be wrong with unbuffered + transaction ?
>>>
>>Check help on Transaction and you will know that's wrong. The process currently takes ~1h. to finish. If we can run the process with exclusive use of the tables, then it would not be much of the problem. However, the original idea was to be able to run it while other users are in the system.
>
>Ok, fair enough. Maybe there will be no other alternative but to run it at night
That's what my manager is doing. He usually starts the Load Process at 5pm after all users go home.
If it's not broken, fix it until it is.
My Blog