Re: Sqlldr versus inserts

John,

Remember you can use the /*+ APPEND */ hint on the inserts, so you will be getting the equivalent of direct path insert. Overall, the performance may not be as high, since you may experience various delays (network, client server, etc.). However, performance may be adequate. Remember the goal is get the data loaded when it is required, not necessarily match your current performance. I'm guessing the developers have other reasons for suggesting this change.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l