我的mycontrol.ctl文件:
load data
infile 'new.dat'
into table TEST_D2
fields terminated by ','
( YEAR NUMBER (10),
DAY NUMBER (10),
TM NUMBER (10),
TMAX NUMBER (10),
TMIN NUMBER (10),
PREC NUMBER (10),
FMAXS NUMBER (10),
FGS NUMBER (10),
SUNSHINE NUMBER (10))
比较简单的方法 - 用nt的at命令加上一个批处理来完成:
D:\>at 21:00 /every:monday,tuesday "test.bat"
Added a new job with job ID = 1
D:\>at
Status ID Day Time Command Line
-------------------------------------------------------------------- 1 Each Monday Tuesday 下午 09:00 test.bat
D:\>type test.bat
sqlldr myuser/mypassword@mydb control=mycontrol