oracle 从文本文件导入数据到数据库表

E:\>sqlldr userid=数据库账号/密码@189.30.100.37/ddyydb  control=d:\temp\dong_jgp.ctl log=d:\temp\dong_jgp.log errors=1000000

dong_jgp.ctl文件内容

load data
infile "d:\temp\jpg_name.csv"
append into table dae_ldjgcs.dong_jpg
fields terminated by ","
OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(
file_name ,
path filler,   #跳过不导入
file_size ,
create_time date"yyyy/mm/dd hh24:mi"
)