Oracle数据库dat数据导入双引号问题

解决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 present
Record 36188: Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY.
second enclosure string not present
Record 43289: Rejected - Error on table T05_HIST_JRNL_FILE_INF, column SMY.
second enclosure string not present
Record 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数据,搜索找到双引号并删除,重新导入就解决了。


Oracle数据库dat数据导入双引号问题
http://pygo2.top/articles/42107/
作者
mingliang.gao
发布于
2023年3月19日
许可协议