Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader problem - constraint violation
I'm new to sqlldr and here is my control file:
LOAD DATA
INFILE '/home/oracle/116.csv'
BADFILE '/home/oracle/116.bad'
DISCARDFILE '/home/oracle/116.rej'
APPEND INTO TABLE LC_F
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt,
cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di
git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty
,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca
rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti
memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp)
lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow?
Here is a snippet from the log file:
Record 1: Rejected - Error on table LC_F. ORA-00001: unique constraint (TEST65W.LCI_LOC) violated
LCI_LOC looks like this:
CREATE UNIQUE INDEX LCI_LOC ON
LC_F(LOC)
If anyone can help, it would be very appreciated.
Thank you,
Saira
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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-LReceived on Mon Jul 07 2003 - 14:56:53 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).