sqlloader errors

[Bill Becker]

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
violations. We are certain that only 1 record really had a violation,
and the other 6 did not.

The records rejected were all consecutive in the .dat file, and the
.log file indicates that sqlloader is using 7 records in each batch
commit.
(Space allocated for bind array:  57792 bytes(7 rows))

Our conclusion is that sqlloader rejected all records in the same
batch because 1 of them had an error.

What is puzzling is that we have several other similar sqlloader processes,
using multiple records in each batch, but all others only reject individual
records with errors, not all records in the same array. The .ctl files for
all of these processes are very similar, and contain mostly the same options:
ROWS=1024, ERRORS=50

The default bindsize on this machine is 64K.

Thanks to any responders.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

sqlloader errors

[Bill Becker]

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: BUGREP )
Bug:1744539  BugDB see Bug:1744539.-PBase Bug:1746223
Related Bugs : BugMatrix:1744539
Customer: ARTESIA SERVICES CV  Created: 19-APR-01
Component: SQLLOADERComp Ver: 8.1.7Rel St: P   Updated: 20-APR-01
Sub Comp:  RDBMS Ver: 8.1.7 By: LDENS
Status: 96,Closed, Duplicate Bug
Sup Pri: 2,Severe Loss of Service Fixed In Ver: 
O/S: 453 Sun SPARC Solaris
PL Group: UNIX  Gen/Port: G  Error #: -  Pub: Y

**

Hdr: 1744539 8.1.7 SQLLOADER 8.1.7 PRODID-5 PORTID-453 1746223
Abstract: SQLLDR REJECTS TOO MANY/FEW RECORDS WHEN PK DEFERRED INIT. IMMEDIATE 
VIOLATION

*** LDENS 04/19/01 02:52 am ***



=
sqlldr rejects too many records when pk deferred initially immediate 
violation.
=
...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).