建立外部表 发生ORA-29913错误
CREATE TABLE log_tab ( text VARCHAR2(80) )
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY alertlog
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
)
LOCATION('orcl_opt_log.log')
)
REJECT LIMIT 999999999;
/建立成功后
SELECT *
FROM ALERT_TAB
WHERE TEXT LIKE '%INS_%';
报告
ORA-29913 ...
ORA-29400
KUP-04020 found record longer than buffer size supported 514288, in e:\log\orcl_opt_log.log
CREATE TABLE log_tab ( text VARCHAR2(80) )
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY alertlog
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
)
LOCATION('orcl_opt_log.log')
)
REJECT LIMIT 999999999;
/建立成功后
SELECT *
FROM ALERT_TAB
WHERE TEXT LIKE '%INS_%';
报告
ORA-29913 ...
ORA-29400
KUP-04020 found record longer than buffer size supported 514288, in e:\log\orcl_opt_log.log
解决方案 »
- 关于group by的问题
- hash join概念
- 我装的是Oracle10G,却怎么也无法登陆,密码绝对没有错误。哪位有办法,请帮帮我!
- 请教一条sql插入语句!
- 从pl_sql写好的一个过程,一保存就到本地,如何放到oracle的procedures中(在线)
- 弱弱的问题
- 请问为什么我进行备份时,结果总是不对呀
- 数据库超难问题!
- 我的问题高手们帮个忙吧,再加100分给有杰出贡献的高手,今晚就结贴如果满意的话
- oracle使用SQL*Plus连接数据库 以及修改scott用户密码,并查询dept表信息
- group by 后选取每一类前三个插入另一个表中
- 求助: <EBS报表开发>使用xml标签,输出表格不正常
CREATE TABLE "DATA_MONITOR"."TB_ALERT_INFO"
( "TEXT" VARCHAR2(400 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "ALERT_DIR"
ACCESS PARAMETERS
( records delimited by newline
nobadfile
nodiscardfile
nologfile
)
LOCATION
( 'alert_ORCL.log'
)
)
REJECT LIMIT UNLIMITED;
text clob都不行你给的例子也还是这个错误
2 'E:oracleproduct10.2.0admintestbdump'
3 ;目录已创建。SQL> create table alert_log(
2 log_text varchar2(4000)
3 )
4 organization external
5 (
6 type oracle_loader
7 default directory bdump
8 access parameters
9 (
10 records delimited by newline
11 nobadfile
12 nodiscardfile
13 nologfile
14 )
15 location('alert_test.log')
16 )
17 reject limit unlimited
18 /表已创建。SQL> select count(*) from alert_log;COUNT(*)
----------
165510SQL> SELECT COUNT(*) FROM ALERT_LOG WHERE LOG_TEXT LIKE 'ORA-%';COUNT(*)
----------
57402