Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sqlldr is ignoring the errors option
I have a file I need to load into a table. There are many duplicates
in the file and I want to ignore all the errors. I put
"errors=1000000" in both the command line and the control file. At
first I had it only in the command line, but I added it to the control
file when I couldn't get it to work there. No matter what I do, sqlldr
stops after 50 errors.
My command line:
sqlldr USERID=$CONNECTSTRING, silent=feedback, errors=1000000, \
control=${WIRX_DATA}/extr/load_ld_prsc_trgt.ctl, \ data=${WIRX_DATA}/data/all_targets.dat, \ log=${LOGDIR}/targets.log, bad=${LOGDIR}/targets.bad
My control file:
--
But still it stops after 50 errors.
The database is Oracle 9i and sqlldr is 9.2.0.4.0.
Anyone aware of this problem? And do you know how to correct it?
Thanks
Ken Denny
Received on Thu Jun 10 2004 - 13:32:34 CDT