options (rows=10000,direct=true,skip=0,errors=10000)
load data
infile ‘文件名‘
truncate into table 表名
fields terminated by ‘,‘
optionally enclosed by ‘"‘
trailing nullcols
(
字段
)
关于日期格式
date类型
"to_date(:列名,‘yyyy-mm-dd hh24:mi:ss‘)"
timestamp类型
timestamp "yyyy-mm-dd hh24:mi:ss"
sqlldr上传oracle
标签：option int nal table to_date error time direct oracle