Re: SQLLDR.exe

"Wilfrid Ertaud" <grille11_at_yahoo.com> wrote:

>Still in the sql loader business...I am trying to load the following csv
>file in mydb.
>
>2;72;"SBF INDUSTRY(AUTOMOBILES)";-1;;;;;
>
>using this command to invoke sqlldr:
>
>sqlldr user/pass_at_DB control=c:\BENCHMARK.csv log=c:\log.tx
>
>and then using this ctl file:
>
>LOAD DATA
>INFILE 'c:\BENCHMARK.csv'
>INTO TABLE ATTR_BENCHMARK1
>FIELDS TERMINATED BY ';'
>(ID NUMBER(10),
>COUNTRY_ID NUMBER(5),
>NAME CHAR(50) OPTIONALLY ENCLOSED BY '"' ,
>ACTIVITY_FLAG NUMBER(2),
>UPDATE_DATE DATE "MM/DD/YYYY",
>JCFQUANT_CODE CHAR(50) OPTIONALLY ENCLOSED BY '"' ,
>DESC_ CHAR(60) OPTIONALLY ENCLOSED BY '"' ,
>CURRENCY_ID NUMBER(5))
>
>The only answer i get is:
>
>SQL*Loader-350: Syntax error in line1.
>Keyword LOAD expected, "2" found.
>2;72;"SBF INDUSTRY(AUTOMOBILES)";-1;;;;;
>^
>
>I feel desperate!
>Is there anyone who could have a divine inspiration?
>thanks in advance
>Wilfrid
>
>"Wilfrid Ertaud" <grille11_at_yahoo.com> a écrit dans le message de news:
>bjniup$kev$1_at_reader1.imaginet.fr...
>> Hello to all Oracle aficionados,
>>
>> I am new in this world and starting to discover the wonders (and
>stability)
>> of this DB system.
>> One thing I am trying to find is how to use the tool sqlldr. I have to
>load
>> a csv file into a table and my guess is this is the right tool.
>> Also is there any limitation in terms of size of record and size of data
>to
>> load (like if I have a 200mb file to load in one shot?)
>> Oracle 8170 SVR and client oraoledb 8172 all on windows 2000.
>> I started to look around on the web without finding the right place.
>> If some one could describe the use or where to find the necessary info I
>> would be eternally gratefull.
>> tanks in advance
>> Wilfrid
>>
>> example of csv file i would like to load:
>>
>> 2;1987;38;153;0;29/04/2003;N;0;;;
>> 2;1987;111;153;0;29/04/2003;N;0;;;
>> 2;1987;115;153;0;29/04/2003;N;0;;;
>> 2;1987;33;153;0;29/04/2003;N;0;;;
>> 2;1987;1;153;0;05/05/2003;N;0;;;
>> 2;1987;15;153;0;05/05/2003;N;0;;;
>> 2;1987;22;153;0;05/05/2003;N;0;;;
>> 2;1987;38;153;0;05/05/2003;N;0;;;
>> 2;1987;111;153;0;05/05/2003;N;0;;;
>> 2;1987;115;153;0;05/05/2003;N;0;;;
>> 2;1987;33;153;0;05/05/2003;N;0;;;
>> 2;1987;1;153;0;03/06/2003;N;0;;;
>> 2;1987;15;153;0;03/06/2003;N;0;;;
>> 2;1987;22;153;0;03/06/2003;N;0;;;
>> 2;1987;38;153;0;03/06/2003;N;0;;;
>> 2;1987;111;153;0;03/06/2003;N;0;;;
>> 2;1987;115;153;0;03/06/2003;N;0;;;
>> 2;1987;33;153;0;03/06/2003;N;0;;;
>>
>>
>

This:
sqlldr user/pass_at_DB control=c:\BENCHMARK.csv log=c:\log.tx is Incorrect
The control should be = to your .ctl file not the .csv..

. Received on Wed Sep 10 2003 - 13:59:14 CDT