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