Re: SQLLDR.exe

From: Wilfrid Ertaud <grille11_at_yahoo.com>
Date: Wed, 10 Sep 2003 20:29:25 +0200
Message-ID: <bjnpki$l95$1_at_reader1.imaginet.fr>


[Quoted] 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;;;
>
>
Received on Wed Sep 10 2003 - 20:29:25 CEST

Original text of this message