Paul Woods wrote:
>
> I'm sure there is a simple answer to this, but right now it's driving me
> nuts. I'm trying to use SQL*Loader to import a comma separated file into a
> table (Oracle 8i on NT).
>
> In an attempt to troubleshoot the problem, I have reduced my control file
> (test2.ctl) to this very simple example:
>
> LOAD DATA
> INFILE *
> REPLACE
> INTO TABLE TESTTABLE
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> (FIRSTNAME, LASTNAME)
> BEGINDATA
> John,Doe
>
> However, no matter what I do, I always get the following error:
>
> SQL*Loader-524: partial record found at end of datafile (test2.ctl)
>
> I get that whether I use an external data file or I include the data in the
> control file. What in the world is causing this?
>
> Thanks,
>
> Paul
This behavior just started occuring with SQL*loader for Oracle8.
Solution...
Always make sure you include a hard "return" key at the end
of the last line of your load control file statements.
Received on Wed Sep 22 1999 - 20:12:57 CDT
