RE: sqlloader tuning

2002-06-26 Thread Deshpande, Kirti
1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:08 AM Hi all, Can any one please tell me what is the

RE: sqlloader tuning

2002-06-26 Thread Seefelt, Beth
Ravi, You can't use sql functions in the control file with direct=true. You can do a direct load, and then run a sql script on the loaded data to make changes. Sometimes the performance gains from the direct load make that worthwhile. Set bindsize=rows*rowlength where rows is the number of

RE: sqlloader tuning

2002-06-26 Thread Nalla Ravi
Hi, Beth and Kirti thank you so much for your clarification. cheers, ravi --- Deshpande, Kirti [EMAIL PROTECTED] wrote: 1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: Multiple