Hello,
Env: Oracle 8.1.6.0.0 on Solaris 2.7
Does anyone know what controls sqlloader behaviour regarding the
number of records it rejects when an error is encountered?
We have a number of daily sqlldr processes; this morning, one
sqlldr process rejected 7 records because of unique constraint
Oracle got back to me (very promptly) regarding the rejection
of several records by sqlloader when only one record in the
batch had an error.
The short answer is that the violated PK constraint, unlike
all others, had been created as DEFERRED.
From Metalink:
**( Source: