Re: SQL*Loader error

invinfo_at_my-deja.com wrote:
>
> I'm getting SQL*Loader-524 error
> partial record found at end of datafile
>
> Of the 3 types of record formats, (Stream, Fixed, Variable),
> I'm trying to use Variable.
>
> my .ctl file looks like this:
>
> load data
> infile 'rjk_dat.txt' "var"
> badfile 'rjk_dat.bad'
> discardfile 'rjk_dat.dsc'
> discardmax 999
> truncate
> into table rjkdata
> fields terminated by ","
> (ndx,
> name,
> dscp)
>
> I've also tried variations, including the TRAILING NULLCOLS clause.
>
> One of my logs listed this:
> Record 1: Rejected - Error on table RJKDATA, column NDX.
> ORA-01722: invalid number
>
> Here are a couple lines of data:
> 1,login,Login error
> 2,databs,Database error
> 3,notes,Notes error
>
> SQL>desc rjkdata
> Name Null? Type
> ------------------------------- -------- ----
> NDX NUMBER(6)
> NAME VARCHAR2(25)
> DSCP VARCHAR2(50)
>
> Suggestions?
> I'm currently looking for resources in Technet and in the Utilities
> Documentation. TIA for your help.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Make sure you have a hard return at the end of the control and data files...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"