oracle sqlldr 出现达到提交点 - 逻辑记录计数 86
出现达到提交点 - 逻辑记录计数 86 就跳出来了,内容如下
C:\Documents and Settings\Administrator>sqlldr wjn/111111@orcl
control = D:\testdate\t_user.ctl
SQL*Loader: Release 10.2.0.1.0 - Production on 星期六 1月 9 11:03:19 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
达到提交点 - 逻辑记录计数 86
C:\Documents and Settings\Administrator>
我的t_user.ctl文件内容如下
load data
infile 'D:\testdate\t_user_dat.csv'
into table t_user
replace
--fields terminated by ','
--Optionally enclosed by ','
(id char terminated by ',',
username char terminated by ',',
password char terminated by ',',
email char terminated by ',',
nickName char terminated by ',',
truename char terminated by ',',
position char terminated by ',',
phone char terminated by ',',
mobile char terminated by ',',
fax char terminated by ',',
state char terminated by ',',
factoryName char terminated by ',',
factoryFullName char terminated by ',',
hangYe char terminated by ',',
groupId char terminated by ',',
createTime date terminated by ',',
userId char terminated by whitespace)
我的数据文件有362条,输出的BAD文件内容跟数据文件一样不同的是只有51行.随意发两行数据文件内容上来
1,Babydaily_bbs,96e79218965eb72c92a549dd5a330112,123,1,1,1,1,1,1,2,Babydaily_bbs,上海贝博氏儿童用品有限公司,hangYe,NULL,2009-09-09 00:00:00,NULL
105,Humidi_rsm,96e79218965eb72c92a549dd5a330112,123,1,1,1,1,1,1,2,Humidi_rsm,瑞思买(北京)信息技术有限公司,hangYe,NULL,2009-09-09 00:00:00,NULL
请问是怎么回事啊? 我刚学用sqlldr . 新手中的新手,还有,ctl文件怎么制定数字类型? 我用int和number都出错?
求高手解答, 在线等