1.目标表结构：
create table TEST(
appliedtime date,
objid number,
data number(8,2),
primary key(appliedtime,objid,data));
2.需要导入的文本数据(c:\test.txt截取部分)：
2008-07-28 00:15:00,26100100,700.00
2008-07-28 00:15:00,26100200,600.00
2008-07-28 00:15:00,26101100,.00
2008-07-28 00:15:00,26102100,350.00
2008-07-28 00:15:00,26109121,126.00
2008-07-28 00:15:00,26109122,.00
2008-07-28 00:15:00,26109211,70.00
2008-07-28 00:15:00,26111101,.00
2008-07-28 00:15:00,26111103,70.00
2008-07-28 00:15:00,26111104,.00
2008-07-28 00:15:00,26111231,180.00
......
3.sqlldr加载脚本(c:\test.ctl)：
Load DATA
INFILE 'C:\test.txt'
Append
INTO TABLE TEST
FIELDS TERMINATED BY ","
(APPLIEDTIME "to_date(:appliedtime,'yyyy-mm-dd hh24:mi:ss')",OBJID,DATA)
4.执行sql loader加载的命令：
sqlldr system/oracle control=c:\test.ctl direct=true log=c:\test.log parallel=true Multithreading=true
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23135684/viewspace-624935/ ，如需转载，请注明出处，否则将追究法律责任。
