Hi,

You have to convert into timestamp,

For eg,
In ctl file,

LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE 'BO_PROMPT_MAP.TXT'
INTO TABLE TRAX_OWNER.BO_PROMPT_MAP
APPEND
FIELDS TERMINATED BY ','
(
AUDIT_REC_CREATE_DTS "TO_TIMESTAMP(:AUDIT_REC_CREATE_DTS,'MM/DD/YYYY
HH24:MI:SS')",
AUDIT_REC_CREATE_APPL_ID CHAR(20)
)
~


Note: The column AUDIT_REC_CREATE_DTS should be of TIMESTAMP datatype.


Cheers

Biju Subrahmanian



-----Original Message-----
From: Vu Linh
[mailto:oracledba-ezmlmshield-x98830952.[Email address protected]
Sent: Thursday, May 22, 2008 6:51 AM
To: LazyDBA Discussion
Subject: RE: ora-01460 when using sqlldr to load the text file to a
timestamp column

Hi DBA
I get error ORA-01460 when using sqlldr to load data from text file
To a column with timestamp data type.

How to fix it ? Thanks
This is my ctl file

LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE 'BO_PROMPT_MAP.TXT'
INTO TABLE TRAX_OWNER.BO_PROMPT_MAP
APPEND
FIELDS TERMINATED BY ','
(
AUDIT_REC_CREATE_DTS DATE 'MM/DD/YYYY HH24:MI:SS',
AUDIT_REC_CREATE_APPL_ID CHAR(20)
)
~

Record 1: Rejected - Error on table TRAX_OWNER.BO_PROMPT_MAP.
ORA-01460: unimplemented or unreasonable conversion requested


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html








This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is
intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to
read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message
in error, please notify the sender immediately and delete all copies of this message.

Oracle LazyDBA home page