Q:SQL*Loader Problem with Date ORA-01861

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Wed, 30 Oct 2002 08:51:57 GMT
Message-ID: <20021030.8515700.1001345629@mis.configured.host>

Hi,

i want to fill in my Table R8 with CSV Data. The file looks like this:
"38F ","38F
","A",911 ,5001 ,"01","001","6183090","2000-03-10","0010610 "
"390 ","390
","A",912 ,5001 ,"01","001","6183100","2000-03-10","0010610 "
"391 ","391
","A",913 ,5001 ,"01","001","6183360","2000-03-10","0010620 "

My Problem is the date. I always get a ORA-01861 Error. Here is my Controlfile:
LOAD DATA
INFILE 'R8'
into table R8
fields terminated by "," optionally enclosed by '"' (

	notesdocid,
	gpfearcid,
	arclevel,
	decdocid INTEGER EXTERNAL TERMINATED BY WHITESPACE,
	doctype INTEGER EXTERNAL TERMINATED BY WHITESPACE,
	ablagekreis,
	mandant,
	rechnr,
	dokdatum "to_date(:DOKDATUM,'YYYY-MM-DD')",
	kundennr

)

What's wrong with dokdatum?
Can Someone help me?

Thx
Ralf Received on Wed Oct 30 2002 - 02:51:57 CST