本地csv文件上传linux
sftp> lcd C:\Users\join\Desktop
sftp> cd /home/oracle
sftp> put impl_0.csv
Uploading impl_0.csv to /home/oracle/impl_0.csv
100% 259766KB 6660KB/s 00:00:39
C:\Users\join\Desktop\impl_0.csv: 266001375 bytes transferred in 39 seconds (6660 KB/s)
执行文件赋值oracle权限
chown oracle impl_0.csv
imp.ctl执行文件文件内容
load data CHARACTERSET AL32UTF8
infile '/home/oracle/impl_0.csv'
append into table bdcdyhlsb fields terminated by ','
trailing nullcols(id,name)
然后转到oracle用户下执行命令
su - oracle
sqlldr userid=jninfo/join@orcl control=/home/oracle/imp.ctl