linux下把csv文件导入oracle

本地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