知识点 | Oracle使用sqlldr批量加载数据！

1. 控制文件编辑
[oracle@ayaudit ~]$ more /oradata/AC16_PRODUCT.ctl

load data
CHARACTERSET 'UTF8'
infile '/oradata/ffp/store_order0402.csv' "str '\n'"
append
into table "FFPAUDIT"."store_order0402"
fields terminated by ','
optionally enclosed by '"'
trailing nullcols
   (
a01,
a02,
a03,
a04,
a05,
a06,
a07,
a08,
a09,
a10,
a11,
a12,
a13,
a14,
a15,
a16,
a17,
a18
 )

复制

2. 执行sqlldr命令批量导入

[oracle@ayaudit ~]$ sqlldr user_name/user_password@TNSname
control=/oradata/AC16_PRODUCT.ctl
bad=/oradata/log/AC16_PRODUCT.bad
log=/oradata/log/AC16_PRODUCT.log
readsize=8024000 bindsize=8024000 errors=999999 skip=1