can anybody tell me what's wrong with my SQL loader ctrl file?

[thg]

Here is my control file:
--------------------------------

LOAD DATA
INFILE 'data1.csv'
REPLACE
INTO TABLE LOANTEMP
(
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
LOAN_NUM INTEGER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
COUPON NUMBER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
SERVICING NUMBER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
DELIQUENCY_DAYS INTEGER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
GROSS_MARGIN NUMBER EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY "\r\n"
)


---------------------------

Here is the error log file:
-------------------------

SQL*Loader: Release 8.1.5.0.0 - Production on Thu Jan 25 18:41:20 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL*Loader-350: Syntax error at line 6.
Expecting valid column specification, "," or ")", found keyword external.
EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
^

------------------------------------------------------------------



The EXTRA_COLUMNs are the columns in my .csv datafile which i don't want to upload. why do i get that error message?

[DBAtrix]

try using
FILLER CHAR instead of
FILLER VARCHAR EXTERNAL

d.