need help again....

[thg]

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.

[goodhealth]

I think you're right. Try rename all columns.