strange sqlloader error

From: felix <mr.thanquol_at_gmx.de>
Date: Tue, 13 Nov 2001 17:01:34 +0100
Message-ID: <9srdag$54$1@crusher.de.colt.net>

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

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 - 10:01:34 CST