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