-
I have this in my control file,
LOAD DATA
INFILE 'data1.csv'
REPLACE
INTO TABLE LOANTEMP
(
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
LOAN_NUM INTEGER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
EXTRA_COLUMN FILLER CHAR TERMINATED BY ',' ,
}
and in the error log, i got this messge.
------------------
SQL*Loader: Release 8.1.5.0.0 - Production on Fri Jan 26 11:30:21 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-404: Column EXTRA_COLUMN present more than once in LOANTEMP's INTO TABLE block.
--------------------------------
Does it mean that I have to use different column name for FILLER columns? since they will not be uploaded anyway, why do they need to have different names?
thg.
-
I think you're right. Try rename all columns.
