SQL*Loader - 524 partial record found at end of datafile

From: Swahanaga <sfinkelman_at_cncdsl.com>
Date: 08 Nov 1999 13:49:26 PST
Message-ID: <382744D0.6F9BA129_at_cncdsl.com>



Hi,
please help!
[Quoted] I've changed the datafiles to use a single delimiter "|' and changed the control file

load data
infile 'myfile.dat'
replace
into table tablename
fields terminated by "|"
(field 1 char,
field2 char,
field3 external decimal,
field4 char)

the datafile specified in the error message is the name of the control file
SQL*Loader - 524 partial record found at end of datafile (myfile.ctl)

I would expect this to be myfile.dat. Received on Mon Nov 08 1999 - 22:49:26 CET

Original text of this message