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 -> SQLLoader failing on duplicate primary keys

SQLLoader failing on duplicate primary keys

From: Dave Siddons <davesiddons_at_lineone.net>
Date: Thu, 14 Nov 2002 16:37:06 -0000
Message-ID: <3dd3d14f_2@mk-nntp-1.news.uk.worldonline.com> 





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
Received on Thu Nov 14 2002 - 10:37:06 CST












Original text of this message













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