Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DB Load fails in Oracle 8

DB Load fails in Oracle 8

From: DL31811 <dl31811_at_aol.com>
Date: 09 Mar 2000 21:03:51 GMT
Message-ID: <20000309160351.02796.00001471@ng-bh1.aol.com>


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 Thu Mar 09 2000 - 15:03:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US