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 rows you want to load before each commit, rowlength is the length of the records in the flat file. To see if you selected appropriate values, run a load of 1 record and generate a log file - sqlldr rows=20000 bindsize=5000000 load=1 log=load.log Check the log to see if you sized appropriately Space allocated for bind array: 4999560 bytes(10245 rows) Read buffer bytes: 5000000 Adjust accordingly - bindsize = 20000*(4999560/10245) = 9760000 sqlldr rows=20000 bindsize=9760000 load=1 log=load.log Space allocated for bind array: 9760000 bytes(20000 rows) Read buffer bytes: 9760000 HTH, Beth -----Original Message----- Sent: Wednesday, June 26, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hi all, Can any one please tell me what is the deciding factor to specify rows value and bindsize value in sqlloader option? is there any option to use direct=true while using function in control file? DB:8.1.7 os:SUN SS thanks for your help. Cheers, Ravi __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
