解决Oracle数据库导入dat数据出现的报错:second enclosure string not present。
背景 今天系统调度跑批,发现17号数据导入有问题。于是用sqlplus、sqlldr手工导入dat数据,打开.log日志有4条数据失败了,提示如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Record 36187 : Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY. second enclosure string not presentRecord 36188 : Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY. second enclosure string not presentRecord 43289 : Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY. second enclosure string not presentRecord 43290 : Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY. second enclosure string not present Table T05_HIST_JRNL_FILE_INF: 54833 Rows successfully loaded. 4 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null .
大概意思是引号缺失,上网查了一下引号可以没有,或者成对出现,
解决方案 打开报错的dat数据,搜索找到双引号并删除,重新导入就解决了。