Greetings.
Do you by chance know if it is possible to tell the SQL*Loader not to insert the data it detects index errors on?
Currently it returns an error code (2) and informs me that it succeeded inserting the aforementioned rows.
The error message is as followed (forgive me for the Swedish text):
The following index(es) on table VALUE_CODE were processed:
index DBONE.INDX_ONSERIALNUM gjordes oanvändbart pga.:
ORA-00001: brott mot unik begränsning (DBONE.INDX_ONSERIALNUM)
indexet DBONE.INDX_MEMBER_GETCOUNT ignorerades på grund av:
SKIP_UNUSABLE_INDEXES angavs och indexsegmentet var oanvändbart före laddningen
indexet DBONE.INDX_MEMBER_REPORT ignorerades på grund av:
SKIP_UNUSABLE_INDEXES angavs och indexsegmentet var oanvändbart före laddningen
index DBONE.INDX_MEMBER_SESSIONID gjordes oanvändbart pga.:
ORA-00001: brott mot unik begränsning (DBONE.INDX_MEMBER_SESSIONID)
indexet DBONE.INDX_CODEANDSTATUS ignorerades på grund av:
SKIP_UNUSABLE_INDEXES angavs och indexsegmentet var oanvändbart före laddningen
laddningen av index DBONE.PK_MEMBER lyckades med 1 nycklar
Table VALUE_CODE:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
The control file looks like this (without columns):
LOAD DATA INFILE 'files\bulk.201804251345'
APPEND PRESERVE BLANKS INTO TABLE MEMBER
fields terminated by "#" optionally enclosed by '|'
trailing nullcols
( REMOVED )