What exactly are the errors you're getting? If there are any non-data
dependent errors, then the load is discontinued immediately.
ken_at_kendenny.com (Ken Denny) wrote in message news:<ba944bc3.0406101032.3ec95ff0_at_posting.google.com>...
> 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:
> --
> -- Load the ld_prsc_trgt table
> --
> options (errors=1000000)
> Load Data
> append into table ld_prsc_trgt
> Fields (
> qtr_cd position (1 : 6) ,
> cid position (23 : 33) ,
> mkt_id position (34 : 44) ,
> brnd_id position (45 : 55) ,
> prsc_of position (83 : 84) ,
> trgt_typ position (85 : 86)
> )
>
> 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 - 22:30:53 CDT
