Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Basic Sqlldr question
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_at_gmail.com> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 12 2005 - 12:57:24 CST