Home » RDBMS Server » Server Utilities » Bulk insert with SQL*Loader fails to abort inserts on index errors (SQL*Loader)
icon4.gif  Bulk insert with SQL*Loader fails to abort inserts on index errors [message #669497] Thu, 26 April 2018 01:12 Go to previous message
ivanskodje
Messages: 3
Registered: April 2018
Junior Member
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 )
 
Read Message icon4.gif
Read Message
Read Message
Read Message
Previous Topic: Sql Loader - oracle
Next Topic: ORA-01722
Goto Forum:
  


Current Time: Mon Jan 20 21:56:48 CST 2020