oracle sql*loader批量导入多个CSV



建立CTL文件  D:\user.ctl  内容：

LOAD DATA
CHARACTERSET UTF8  --UTF8编码
INFILE 'D:\xx\最后5000.csv'
INFILE 'D:\xx\1-200W.csv'
INFILE 'D:\xx\1000W-1200W.csv'
INFILE 'D:\xx\1200W-1400W.csv'
APPEND INTO TABLE kf
FIELDS TERMINATED BY ',' --以逗号分隔
TRAILING NULLCOLS
(Name,CardNo,Descriot)

在CMD中运行以下命令:

sqlldr userid=hr/m123 control=D:\user.ctl parallel=true

成功导入！

参考

http://database.ctocio.com.cn/214/12154214_2.shtml

http://blog.youkuaiyun.com/nsj820/article/details/6740664

http://blog.youkuaiyun.com/cupid1102/article/details/7357510