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: emerald <emerald_at_net.hr>
Date: Thu, 14 Nov 2002 21:42:27 +0100
Message-ID: <ar11q7$ou4$1@sunce.iskon.hr>

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:3DD3D7BE.E00E4499_at_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
>

true, true Received on Thu Nov 14 2002 - 14:42:27 CST

Original text of this message

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