Re: SQLLoader failing on duplicate primary keys

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 14 Nov 2002 14:23:10 -0800
Message-ID: <3dd4224e@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 Thu Nov 14 2002 - 16:23:10 CST