sqlldr 导入timestamp类型数据

控制文件：
load data
infile 'E:\test.data'
replace
into table test_time
fields terminated by ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
sjc timestamp 'yyyy-mm-dd HH24:MI:SS.FF'
)

数据文件：
2014-08-02 12:31:45.450000000
2014-08-02 12:31:45.450000000
2014-08-02 12:31:45.450000000
2014-08-02 12:31:45.450000000
2014-08-02 12:31:45.450000000
2014-08-02 12:31:45.450000000
DOS下：
set nls_date_format=YYYY-MM-DD HH24:MI:SS


sqlldr topicis/oracle control=E:\test.ctl log=E:\test.log