Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader-524: partial record found at end of datafile

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

From: Tom Zamani <tom_at_taten.com.au>
Date: Wed, 13 Oct 1999 10:00:42 +1000
Message-ID: <7u0i4n$gha$1@perki.connect.com.au>


Make sure the ) in you CTL File is on a seperate line. Tom
Nick wrote in message <3803C817.8009992C_at_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 - 19:00:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US