Question:

> 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

Answer 1:

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.

Answer 2:

Off the top of my head.....

don't you need a trailing comma????

e.g.