sqlldr简单例子

sqlldr userid=username/aiki control=aiki.ctl log=ftp.log bad=ftp.bad;

more aiki.ctl

load data　
infile 'ftp.txt'　
truncate into table gis_stat
fields terminated by X'09' ---excel格式拷出
(system varchar2(10),
areacode number(5),
servername varchar2(35),
times varchar2(15),
total number(10),
t10s number(9),
t30s number(9),
t60s number(9)
)