>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.
If it's not broken, fix it until it is.
My Blog