Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLoader failing on duplicate primary keys
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