Re: Load error

Hi,

I've had the same problems! The reason was my editor, which inserted a (invisible) End-Of-file-sign at the end of the CTL-File. Try notepad or
configure your editor to do not insert a eof-character at end of ctl-files.

regards
Dieter

Jerry Gitomer schrieb:
>
> Hi marcus,
>
> What does your log file say? It should have better
> information. You can also specify a "bad" file, rerun your load
> (after truncating the table), rerun the load and then look as the
> bad file.
>
> hth
> jerry gitomer
>
> marcus_chan_at_my-deja.com wrote in message
> <7ua2vc$cga$1_at_nnrp1.deja.com>...
> >Hi Martin,
> >
> >I've tried to either removing and adding a blank line after the
> end of
> >the data file. Still having the same error. Any suggestion???
> >
> >marcus
> >In article <3805AA7C.F7BB3962_at_totalise.co.uk>,
> > Martin Hepworth <maxsec_at_totalise.co.uk> wrote:
> >> marcus_chan_at_my-deja.com wrote:
> >> >
> >> > Hi,
> >> >
> >> > i'm new to Oracle. I've installed Oracle vr 8.0.5
> >> > when I tried to load a delimeted file to a table I received
> this
> >error
> >> > SQL*Loader: Release 8.0.5.0.0 - Production on Thu Oct 14
> 17:2:10
> >1999
> >> >
> >> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >> >
> >> > SQL*Loader-524: partial record found at end of datafile
> >> > (C:/soh/test.ctl)
> >> >
> >> > Below is my description
> >> > Control file:
> >> > =============
> >> > LOAD DATA
> >> > INFILE 'c:\soh\admin_login.dat'
> >> > INTO TABLE EBXCSLDT.ADMIN_LOGIN
> >> > FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> >> > (admin_id, password, accs_right, log_key NULLIF
> log_key=BLANKS)
> >> >
> >> > Data file
> >> > =========
> >> > "admin","password",0,""
> >> > "admin1","password",1,""
> >> > "admin2","password",2,""
> >> > "admin3","password",3,""
> >> >
> >> > table description
> >> > =================
> >> > SQLWKS> describe ebxcsldt.admin_login
> >> > Column Name Null? Type
> >> > ------------------------------ -------- ----
> >> > ADMIN_ID NOT NULL VARCHAR2(25)
> >> > PASSWORD NOT NULL VARCHAR2(25)
> >> > ACCS_RIGHT NOT NULL NUMBER(38)
> >> > LOG_KEY VARCHAR2(40)
> >> >
> >> > What is wrong here?
> >> > marcus
> >> >
> >> > Sent via Deja.com http://www.deja.com/
> >> > Before you buy.
> >>
> >> Marcus
> >> have you got a blank line at the end of the file ie..
> >>
> >> Data file
> >> =========
> >> "admin","password",0,""
> >> "admin1","password",1,""
> >> "admin2","password",2,""
> >> "admin3","password",3,""
> >>
> >> ============
> >>
> >> Rather than
> >> Data file
> >> =========
> >> "admin","password",0,""
> >> "admin1","password",1,""
> >> "admin2","password",2,""
> >> "admin3","password",3,""
> >> =====================
> >>
> >> Martin
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
Received on Thu Oct 21 1999 - 06:10:07 CDT