Re: strange sqlloader error

I would first check the .bad file to see which record it contains. Next I would set the errors allowed to a number greater than 0; you may do that in the control file or on the command line, it's your choice. To set this in the control file:

 options (errors = 500)
 load data
 infile '/path/to/contactvalues.csv'
 into table contactvalues
 fields terminated by ',' TRAILING NULLCOLS  (

    ProspectID                 ,
    DateCreated                ,
    ContactTypeID              ,
    CampaignID                 ,
    ContactDescr               ,
    DateValidFrom              ,
    DateValidTo                ,
    IDinSource                 

On the command-line:

sqlldr user/pass /path/to/contactvalues.ctl errors=500

See if this helps you determine why your data isn't loading.

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
Received on Wed Nov 14 2001 - 09:19:41 CST