Jack, The first thing I would consider is disabling the constraints and using the direct path loader. Then after each load, run SQL statements to create a report of constraint violations. That might help your log switch problem and maybe your overall project time. Dennis Williams