SQL*Loader-524 is in the i/o error range. The problem could be the file and
not the data.
<marcus_chan_at_my-deja.com> wrote in message
news:7ujunn$pir$1_at_nnrp1.deja.com...
> Hi Jerry,
>
> below is the content of the log file:
> SQL*Loader: Release 8.0.5.0.0 - Production on Wed Oct 20 15:49:6 1999
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> SQL*Loader-524: partial record found at end of datafile (testing.ctl)
>
> No bad bile is produced.
>
> thanks
> marcus
> In article <7uicfb$2iv$2_at_autumn.news.rcn.net>,
> "Jerry Gitomer" <jgitomer_at_hbsrx.com> wrote:
> > 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.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 20 1999 - 05:48:57 CDT
