加载中…Oracle外部表 查询报错 ORA-30653: reject limit reached
(2014-03-31 01:21:29)
标签：
oracle外部表ora-30653it |
分类： Oracle |
最近浅显的研究外部表
利用前一段时间热门的2000w泄露数据库 文件进行测试
文件是从sql2005数据库通过bcp导出的 逗号分割纯文本 大小2Gb
create table t_2000w (
uname varchar2(80),
uuid varchar2(50),
usex varchar2(20),
ubirth varchar2(30),
uaddress varchar2(250),
umobile varchar2(30),
uemail varchar2(30),
uminzu varchar2(50),
unot varchar2(30),
utime varchar2(80))
organization external(
type oracle_loader
default directory dir_ext
access parameters(
records delimited by newline
fields terminated by ',')
location('out.by.name.txt')
);
创建OK 查询的时候报错
select count(*) from t_2000w;
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
ORA-06512: at "SYS.ORACLE_LOADER", line 52
解决方法是
alter table t_2000w reject limit unlimited;
ORA-30653: reject limit reached
Cause: the reject limit has been reached.
Action: Either cleanse the data, or increase the reject
limit.
ORA-30645: reject limit out of range
Cause: Reject limit specifies the number of records rejected
before terminating a table scan. The range is a either a number
between 1..100000 or UNLIMITED if no limit is intended.
Action: Change the token representing the reject limit to
either a number in the range of 0 and 100000 or the keyword
UNLIMITED.
==转=============
oracle外部表
喜欢
0
赠金笔