Re: DB Load fails in Oracle 8

I am somewhat new to Oracle but your load statement does not match your data. It seems your input file is a comma-delimited file using a single quote to enclose all your data (both numeric & character).

You might want to try something like
LOAD DATA
infile ' ......'
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY " ' "
into table.....

DL31811 wrote:

> I use Oracle 8 for Win NT 4.0 and try a DB-Load with the Data-Manager-Wizard
> (successless):
>
> The DB-Load fails always with message "Stapelüberlauf" (stack overflow)
> (Connected as user dirk, rights should be o.k.)
> I don´t know why.
>
> The control file on the local machine reads:
>
> load data
> infile 'G:\Daten\O8_Import\Auftrag.dat'
> into table auftrag
> append
> (anum position(01:10) number(10,0),
> knam position(11:40) varchar2(30),
> kada position(41:70) varchar2(30),
> kadb position(71:100) varchar2(30,
> data position(101:106) date 'DDMMYY',
> ldat position(107:112) date 'DDMMYY',
> lada position(113:142) varchar2(30),
> ladb position(153:172) varchar2(30))
>
> (Tabledef. is checked, O.K., Path is checked, O.K, Tableowner is Dirk)
>
> One line of Data file "Auftrag.dat" (includes 90 records):
> ('92','Blohm','Königsallee 19','Düsseldorf','15.11.98','29.11.98','Königsallee
> 19','Düsseldorf');
>
> Data Path: Both Conventional and direct used.
> Rows per commit: 64
>
> The log-file: "Load.cmd " (log) says:
> USERID =dirk/dirk Der Befehl ist falsch geschrieben oder konnte nicht gefunden
> werden. Überprüfen Sie die Schreibweise und die Umgebungsvariable "PATH".
>
> Can someone help me?
> I have no idea.
> Thanks, Dirk
Received on Fri Mar 10 2000 - 21:16:40 CST