help:sql*loader
参数文件如下:
userid=user/psw
control=input.ctl
log=input.log
bad=input.bad
errors=1
skip=0
控制文件(input.ctl)如下:
load data
infile 'input.csv'
append into table test
trailing nullcols
(first char terminated by ",",
second char terminated by "," optionally enclosed by '"'
)
数据文件(input.csv)如下:
"2","110"
"2","120"
日志文件如下:
SQL*Loader: Release 8.1.5.0.0 - Production on 星期五 11月 23 19:13:27 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-524: 在 datafile (input.ctl) 结尾发现部分记录
请问大虾们,我到底做错了什么?