Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr and discarded records

Re: sqlldr and discarded records

From: Christoph Seidel <christoph.seidel1_at_gmx.de>
Date: Sat, 15 Mar 2003 10:27:55 +0100
Message-ID: <b4urpl$21u8kk$1@ID-143718.news.dfncis.de>


TurkBear wrote:
> I may have missed why you have not, but, if you put a primary key on
> the table you are importing into, any duplicates ( that is,
> previously loaded and committed by the failed loader job) will be
> rejected..set your errors parameter high enough and it should be
> fine...

there is no pk in the input file
and... it seems to be no good strategie Received on Sat Mar 15 2003 - 03:27:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US