Re: sqlldr is ignoring ERRORS option

Naren wrote:
> Hi,
>
> The data file contains records that violate referential integrity
> constraints. What I expect is that the load should abort as soon as
> first error is encountered, and because all the rows in the data file
> can fit in the BindArray, none of the rows should get committed.
> Instead, the load doesn't abort and it loads the data in one of the
> tables and also report the errors in the log file. Following is the log
> file:

Read this, perhaps you need to adjust your expectations: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10825/ldr_params.htm#sthref548

>
> Any help on this topic will be highly appreicated.
>
> TIA,
> Naren

jg

--
@home.com is bogus.
http://www.forbes.com/2006/02/28/cz_mh_0228worsebugslide.html