Re: SQLLoader failing on duplicate primary keys

Thanx for the help everyone.

I have no access to the system in question. This was a question posed to me over the phone. Apologies for posing such a simple question that evidently insulted your supreme intelligence.

"Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> wrote in message news:3dd4224e_at_news.victoria.tc.ca...
> Daniel Morgan (dmorgan_at_exesolutions.com) wrote:
> : 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
>
> And assuming his test setup doesn't have any bugs and assuming the
> apparently inexperienced user correctly interprets what he sees, then
> he'll know the answer.
>
Received on Fri Nov 15 2002 - 04:25:56 CST