Re: strange sqlloader error

Well, it appears that the ERRORS parameter is set to zero. Try increasing that to a rather larger value, run the load again, and see what happens.

Also, you should check the bad file containing the actual rows that are rejected for loading. It's default name is whatever your control file is called, with an extension of '.bad', but you can force it to be anything you want by setting the BAD= parameter.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"felix" <mr.thanquol_at_gmx.de> wrote in message
news:9srdag$54$1_at_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

>

> (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