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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLoader failing on duplicate primary keys

Re: SQLLoader failing on duplicate primary keys

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 14 Nov 2002 17:05:06 GMT
Message-ID: <3DD3D7BE.E00E4499@exesolutions.com>


Dave Siddons wrote:

> When loading data via SQLLoader if a record violates the primary key does
> SQLLoader just stop loading or throw the offending record to the BADFILE.
>
> Also How do you alter the maximum number of errors (to the BADFILE) from 50
> to several thousand.
>
> Cheers for any help ...
>
> Dave

It would have taken fewer minutes to build a test table and a control script and try it than it took to log onto this usenet group and ask.

Daniel Morgan Received on Thu Nov 14 2002 - 11:05:06 CST

Original text of this message

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