SQL*Loader error
Date: Tue, 05 Dec 2000 20:57:02 GMT
Message-ID: <90jkqr$o2f$1_at_nnrp1.deja.com>
I'm getting SQL*Loader-524 error
[Quoted] 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.
Received on Tue Dec 05 2000 - 21:57:02 CET