Re: strange sqlloader error

You didn't include the table description. Are all the columns in your table character types or do you have number and date types that are going through some sort of implicit conversion?

Richard

felix wrote:
>
> hi,
>
> I want to import a .csv file to my oracle 8.1.7 server. I created the
> correct table and the control-file for the sqlloader looks like this:
>
> load data
> infile '/path/to/contactvalues.csv'
> into table contactvalues
> fields terminated by ',' TRAILING NULLCOLS
> (
> ProspectID ,
> DateCreated ,
> ContactTypeID ,
> CampaignID ,
> ContactDescr ,
> DateValidFrom ,
> DateValidTo ,
> IDinSource
> )
>
> now I run the sqlloader and after 2 records it stops. here is the logfile:
>
> SQL*Loader: Release 8.1.7.0.0 - Production on Tue Nov 13 15:45:37 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Control File: /path/to/contactvalues.ctl
> Data File: /path/to/felix/contactvalues.csv
> Bad File: /path/to/felix/contactvalues.bad
> Discard File: none specified
>
> (Allow all discards)
>
> Number to load: ALL
> Number to skip: 0
> Errors allowed: 0
> Bind array: 64 rows, maximum of 65536 bytes
> Continuation: none specified
> Path used: Conventional
>
> Table CONTACTVALUES, loaded from every logical record.
> Insert option in effect for this table: INSERT
> TRAILING NULLCOLS option in effect
>
> Column Name Position Len Term Encl Datatype
> ------------------------------ ---------- ----- ---- ----
> ---------------------
> PROSPECTID FIRST * , CHARACTER
>
> DATECREATED NEXT * , CHARACTER
>
> CONTACTTYPEID NEXT * , CHARACTER
>
> CAMPAIGNID NEXT * , CHARACTER
>
> CONTACTDESCR NEXT * , CHARACTER
>
> DATEVALIDFROM NEXT * , CHARACTER
>
> DATEVALIDTO NEXT * , CHARACTER
>
> IDINSOURCE NEXT * , CHARACTER
>
>
> MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
>
> Table CONTACTVALUES:
> 2 Rows successfully loaded.
> 1 Row not loaded due to data errors.
> 0 Rows not loaded because all WHEN clauses were failed.
> 0 Rows not loaded because all fields were null.
>
> Space allocated for bind array: 63984 bytes(31 rows)
> Space allocated for memory besides bind array: 0 bytes
>
> Total logical records skipped: 0
> Total logical records read: 31
> Total logical records rejected: 1
> Total logical records discarded: 0
>
> Run began on Tue Nov 13 15:45:37 2001
> Run ended on Tue Nov 13 15:45:37 2001
>
> Elapsed time was: 00:00:00.21
> CPU time was: 00:00:00.04
>
> But I can't see an error in here
>
> any idea's?? thx in advance
>
> fe
Received on Tue Nov 13 2001 - 14:02:45 CST