oracle快速导入

--oracle 快速导入
Sqlldr dbname/dbpwd@dbservice control=e:\import.ctl direct=true data=e:\tm_user.csv

--ctl文件
load data
characterset 'utf8'
infile 'e:\tm_user.csv'
append
into table tm_user
fields terminated by ','  optionally enclosed by '"'
trailing nullcols
(
load_dt date 'yyyy-mm-dd hh24:mi:ss',
userid,
usercode,
username
)