Question

oracle sqlldr插入timestamp字段类型数据如何实现

控制文件如下
load data
infile 'E:\test.txt'
insert into table test
fields terminated by ',' optionally enclosed by '"'
trailing nullcols
(EXPLAIN_REQUESTER,
EXPLAIN_TIME "TO_TIMESTAMP(:EXPLAIN_TIME, 'DD-Mon-RR HH24:MI:SS.FF')",
SOURCE_NAME,
SOURCE_SCHEMA,
SOURCE_VERSION,
EXPLAIN_LEVEL,
STMTNO,
SECTNO,
OPERATOR_ID,
ARGUMENT_TYPE,
ARGUMENT_VALUE,
LONG_ARGUMENT_VALUE)
数据文件：
"TOPICIS ","27-12月-10 05.29.41.578001000 下午","SYSSH200","NULLID "," ","P","1","65","2","WRAPPING","TRUE",""
"TOPICIS ","27-12月-10 05.29.41.578001000 下午","SYSSH200","NULLID "," ","P","1","65","2","SPEED ","FAST",""
"TOPICIS ","27-12月-10 05.29.41.578001000 下午","SYSSH200","NULLID "," ","P","1","65","2","THROTTLE","TRUE",""
"TOPICIS ","27-12月-10 05.29.41.578001000 下午","SYSSH200","NULLID "," ","P","1","65","2","LCKAVOID","TRUE",""
"TOPICIS ","27-12月-10 05.29.41.578001000 下午","SYSSH200","NULLID ","
记录 1: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 2: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 3: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 4: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 5: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 6: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 7: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 8: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份
记录 9: 被拒绝 - 表 TEST 的列 EXPLAIN_TIME 出现错误。
ORA-01843: 无效的月份

Answer 1

EXPLAIN_TIME "TO_TIMESTAMP(:EXPLAIN_TIME, 'DD-Mon-RR HH24:MI:SS.FF')" 这一行换成这样

EXPLAIN_TIME TIMESTAMP ’DD-Mon-RR HH24:MI:SS.FF‘
试一下，告诉我结果