Re: strange sqlloader error

From: felix <mr.thanquol_at_gmx.de>
Date: Wed, 14 Nov 2001 14:00:47 +0100
Message-ID: <9stn3t$97e$1@crusher.de.colt.net>

Howard J. Rogers wrote:

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

[...]

>>
>>
>> But I can't see an error in here
>>
>> any idea's?? thx in advance
>>
>> fe

>
>
>

hi,

I found the problem... I took the wrong field as primary key and there are some duplicates in it .... sorry but thx a lot!!

fe Received on Wed Nov 14 2001 - 07:00:47 CST