Help with error -- SQL*Loader-524

From: Peter A Huegler <phuegler_at_epix.net>
Date: Thu, 17 Sep 1998 15:01:08 -0400
Message-ID: <6trm8v$d5o$1_at_news.ses.cio.eds.com>

I am trying to load an oracle table from an ascii flat file. Each record in the file is terminated with a CR/LF and is the same length. There are 5817 records in the file. The last character of the file is an end-of-file marker (ascii 26). I was using SQL*Loader 7.3.4.1.0 and the file loads A-OK. I have since upgraded to SQL*Loader 8.0.5.0.0 and now I have problems. I get the following error:

SQL*Loader-524: partial record found at end of datafile (lf11b70e.)

I have not made any changes to the SQL*Loader control file nor my operating system (which is NT 4.0).

Here is the output from sqlldr73:

SQL*Loader: Release 7.3.4.1.0 - Production on Thu Sep 17 14:24:08 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Commit point reached - logical record count 799
Commit point reached - logical record count 1598
Commit point reached - logical record count 2397
Commit point reached - logical record count 3196
Commit point reached - logical record count 3995
Commit point reached - logical record count 4794
Commit point reached - logical record count 5593
Commit point reached - logical record count 5917

Here is the output from sqlldr80:

SQL*Loader: Release 8.0.5.0.0 - Production on Thu Sep 17 14:24:16 1998

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Commit point reached - logical record count 799
Commit point reached - logical record count 1598
Commit point reached - logical record count 2397
Commit point reached - logical record count 3196
Commit point reached - logical record count 3995
Commit point reached - logical record count 4794
Commit point reached - logical record count 5593
Commit point reached - logical record count 5917

SQL*Loader-524: partial record found at end of datafile (lf11b70e.)

I have tried many ways to stop the error with the WHEN clause but I have been unsuccessful.

Any ideas or help with this will be greatly appreciated.

TIA Pete Received on Thu Sep 17 1998 - 21:01:08 CEST