Thanks Jared, Jonathan, We solved by using ## as a delimiter and the files are loading fine. And Jared, thanks for the wonderful script<http://www.jaredstill.com/content/dump.html>you have on your site to dump a table for sqlldr. I used it to generate a control file to upload the data. Now instead of couple of hours to load about 2m rows (thru perl process), it takes about 220 seconds using sqlldr. and since this will be done every hour, The time savings are huge. thanks Raj On 12/12/05, Jared Still <jkstill@xxxxxxxxx> wrote: > > > In this case the double quotes appeared in succession at the end of the > string: eg. data""," > > You might like to look at the SQL*Loader Control File reference in the > Utilities manual. > > HTH > > Jared >