数据在SQLLDR的时候提示错误
在逻辑记录结束之前未找到列
1.sale.log文件
Record 10: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 11: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 12: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 14: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 16: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 18: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 19: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 20: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 21: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 22: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 25: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 30: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 33: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 34: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 35: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 36: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 39: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 40: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 44: Rejected - Error on table TMP3, column EMAIL2.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 51: Rejected - Error on table TMP3, column EMAIL2.
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table TMP3:
70 Rows successfully loaded.
51 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.
Space allocated for bind array: 99072 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 121
Total logical records rejected: 51
Total logical records discarded: 0
Run began on Fri Jun 27 16:02:28 2014
Run ended on Fri Jun 27 16:02:31 2014
Elapsed time was: 00:00:02.99
CPU time was: 00:00:00.01
1.查看bad文件，找到错误数据是否与 要导入的excel或者txt文件的列数、要导入的目标表的列数一致
2.如果列一致，查看最后一列是否为空,如果最后一列为空,sqlldr运行时会报错
加上trailing nullcols （表的字段没有对应的值时允许为空 ）,
将所有不在纪录中的指定位置的列当作空值,指记录中没有内容（空格、空白、或null）的列被当作null
load data
infile 'sale418.csv'
into table tmp3
fields terminated by ','
trailing nullcols -----将所有不在纪录中的指定位置的列当作空值
(username,phone1,phone2,phone3,email1,email2)
这里用 excel
数据
做个最简单的测试。 1）把 excel
数据
存为 t.txt 文件，注意文件后缀名为 .txt 1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04 2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04 3 jhchen 11/07/2005 20:04:00 2005-11-7 20:04 2）SQL> create table t_load( id number, name varchar2(10), dat1 date, dat2 date, dat3 date ); Table creat
数据
在
SQLLDR
的时候
提示
错误
记录 2407: 被拒绝 - 表 XXX的列 XXX 出现
错误
。
在逻辑记录结束之前未找到列（
使用
TRAILING
NULLCOLS
）
1.input.log文件
SQL*Loader: Release 10.2.0.1.0 - Production on 星期六 12月 31 19:59:58 2011
SQL*Loader对不同文件及格式的处理方法
1.大字段(LOB类型)的导入
LOB作为大字段
数据
类型，是Oracle新增的
数据
类型，用来替代long和long raw类型，一般
sqlldr
操作中不会涉及大字段类型的操作，如果你遇到了这种需求，一般分以下两种情况处理：
1）
数据
保存在
数据
文件中
以Manager表为例，修改Remark字段为lob类型
SQL> alter table
用java写一个很简单的
数据
库访问程序，但是如果表跟字段中出现中文，会出现这样的
错误
：java.sql.SQLException: Column not found
解决方法之一是在连接是指定gb2312
Properties prop = new Properties();
prop.put("charSet", "gb2312");
prop.put("username", usernam...
有这么一个
数据
，按照一分钟统计
数据
的查询数，字段内容：
stat_date date, stat_num number(10)
stat_date表示统计日期，stat_num表示统计数目
数据
如下：
2009-0...
mysql -h192.***.1.80 -P3306 -uroot -proot ltfz_190523<D:/ylznSQL/ltfz_190523.sql
ERROR 1292 (22007) at line 6061: Incorrect date value: '0000-00-00' for column 'date' at row 1
