linux 执行sql loader,sql loader使用例子

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