Re: SQL*Loader - 524 partial record found at end of datafile
From: Marty Grinstead <MGrinstead_at_email.msn.com>
Date: Mon, 8 Nov 1999 18:44:43 -0500
Message-ID: <O8#4ENkK$GA.222_at_cpmsnbbsa03>
Date: Mon, 8 Nov 1999 18:44:43 -0500
Message-ID: <O8#4ENkK$GA.222_at_cpmsnbbsa03>
Make sure your control file ends with a carriage return.
Swahanaga wrote in message <382744D0.6F9BA129_at_cncdsl.com>...
>Hi,
>please help!
>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 Tue Nov 09 1999 - 00:44:43 CET