SQL*Loader-524 error: tries to read .ctl file as data?

From: Helmuth Kristen <hkristen_at_cfa.harvard.edu>
Date: Mon, 23 Aug 1999 15:15:12 -0400
Message-ID: <37C19DB1.4721CFE3@cfa.harvard.edu>

Hi,
we are trying to load a number of datafiles into tables using SQL*Loader. For some, not all, files
we keep getting the error message:

SQL*Loader-524: partial record found at end of datafile (C:\Jacob\ctl_files\Creese_1995.ctl)

and no data are loaded into the table.

Are we right suspecting that SQL*Loader for some reason thinks that it should read
the .ctl-file as a data-file? We do specify the correct data-file name in the .ctl file.
We have carefully compared the control files that work with those that do not, but
cannot isolate the error.

We have tried looking for strange characters in the data and control files, and
we have entered a carriage return at the end of these; nothing helped.

Does anyone recognize the problem described?

Thankful for any help,

Helmuth Kristen Received on Mon Aug 23 1999 - 14:15:12 CDT