控制文件:
load data
infile case10.dat.txt "fix 63"
replace into table manager
(
mgrno position(1:2),
mname position(4:10),
job position(12:24),
re position(26:63)
)
数据文件:
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加载程序无法继续而被终止
求解!
load data
infile case10.dat.txt "fix 63"
replace into table manager
(
mgrno position(1:2),
mname position(4:10),
job position(12:24),
re position(26:63)
)
数据文件:
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加载程序无法继续而被终止
求解!
he is a tech manager.加一块才61个字符啊,不可能超啊!