Oracle Import "sqlldr" importing date

[jaymink]

I am facing problem in using sqlldr.

contains of my .ctl file:
load data
infile 'tmp1.txt'
into table dpw_voice_success_40
fields terminated by ' '
(calltime DATE(20) "DD/mm/YYYY hh:mm:ss", Number)

my tmp1.txt file contains:

15/12/2003 00:00:03 919891145819

Here I am facing problem in importing data of Date.

Error:

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
CALLTIME FIRST 20 WHT DATE DD/mm/YYYY hh:mm:ss

Record 1: Rejected - Error on table DPW_VOICE_SUCCESS_40, column CALLTIME.
ORA-01810: format code appears twice


Help required.

Regards,

Jaymin Kavaiya

 

[THoey]

Minutes should be MI...

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[ddrillich]

Please try:

(
calltime "TO_DATEcalltime,'DD/mm/YYYY hh:mi:ss')"
)

Regards,
Dan