SQL*Loader-524: partial record found at end of datafile

From: Nick <nick_j_at_mailcity.com>
Date: Wed, 13 Oct 1999 09:45:28 +1000
Message-ID: <3803C817.8009992C@mailcity.com>

Hi,

We are getting the following error when trying to load data from a set of data files, if anyone has any ideas, that would be great. TIA,

-Nick

bash-2.02$ sqlload userid=user/user_at_user control=user.ctl direct=true bad=badfile.bad log=logfile.log
SQL*Loader: Release 8.0.5.0.0 - Production on Wed Oct 13 9:49:39 1999 (c) Copyright 1998 Oracle Corporation. All rights reserved. SQL*Loader-524: partial record found at end of datafile (user.ctl)

This is the contents of our user.ctl file:

load data
infile 'user'
insert
into table user
fields terminated by '|'

(       ar_key,
        ar_bacat,
        ar_lib,
        ar_oms)

Our user.dat file:

N  |N|                    |Undefined
PN |P|Makes not in PS     |Passenger Non Stand.
PS |P|FOR-HOL-TOY-MIT     |Passenger Standard

H |H|Greater than 4500 kg|Heavy Commercial L |L|Less than 4500 kg |Light Commercial Received on Tue Oct 12 1999 - 18:45:28 CDT