Re: sqlldr and discarded records

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Mon, 17 Mar 2003 12:57:31 +0500
Message-ID: <b53v5n$25ie1p$1@ID-127142.news.dfncis.de>

Hi,

then you can try to add unique constraint for all fields to the table if it suitable in your situation...

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote in message
news:b4urpl$21u8kk$1_at_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 Mon Mar 17 2003 - 01:57:31 CST