控制文件:
load data
infile case10.dat.txt "fix 61"
replace into table manager
(
mgrno position(1:2),
mname position(4:10),
job position(12:24),
re position(26:61)
)
数据文件:
10 smith sales manager this is smith.
he is a sales manager.
11 allen.w tech manager this is allen.w.
he is a tech manager.
16 blake hr manager this is blake.
he is a hr manager.
输入命令后出现错误提示:sql*loader-501:无法读取文件(case10.dat.txt)
sql*loader-566:在数据文件的结尾处找到部分记录
sql*loader-2026:加载因sql加载程序无法继续而被终止
查看case10.dat.bad文件,如下
r.
11 allen.w tech manager this is allen.w.
he is a tech manager.
16 blake hr manager this is blake.
he is a hr
为什么只导入了头和尾的一部分?求解!
load data
infile case10.dat.txt "fix 61"
replace into table manager
(
mgrno position(1:2),
mname position(4:10),
job position(12:24),
re position(26:61)
)
数据文件:
10 smith sales manager this is smith.
he is a sales manager.
11 allen.w tech manager this is allen.w.
he is a tech manager.
16 blake hr manager this is blake.
he is a hr manager.
输入命令后出现错误提示:sql*loader-501:无法读取文件(case10.dat.txt)
sql*loader-566:在数据文件的结尾处找到部分记录
sql*loader-2026:加载因sql加载程序无法继续而被终止
查看case10.dat.bad文件,如下
r.
11 allen.w tech manager this is allen.w.
he is a tech manager.
16 blake hr manager this is blake.
he is a hr
为什么只导入了头和尾的一部分?求解!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货