LOAD DATA
CHARACTERSET ‘UTF8’
INTO TABLE nanjingyuhuatai_20210507ceshi
Append
FIELDS TERMINATED BY ‘,’
optionally enclosed by ‘"’
TRAILING NULLCOLS
(
ID,branchid,ppaddress1,ppaddress2,ppaddress3
,AREACODE,ISSETCODE,POLICYNO,ppdate timestamp “yyyy/mm/dd”
,CUSTOMERNAME,IDCARD1,risktype
,YEARNUM,PAYtype,RECTELE,POLIST,APTELE,PTELE
)
语句如图:
sqlldr gisbiz/gisbiz@44 data=F:\0HUAQU\ddaoshu\原始数据不全\雨花台.CSV control=F:\0HUAQU\ddaoshu\KUOQUceshi.ctl log=F:\0HUAQU\ddaoshu\2021050801log.log bad=F:\0HUAQU\ddaoshu\2021050801bad.txt errors=999999
当导入数据时提示的列 ID 出现错误。
数据文件的字段超出最大长度,用editplus打开后发现有很多” ,这时就要加上optionally enclosed by ‘"’,然后再继续用csv导入。