oracle 新增之后 触发,创建external table后，执行查询报错

操作系统平台是xp

数据库版本是

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE    10.2.0.1.0      Production

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

我建立了一个external table

create table external_load_tester

( OWNER VARCHAR2(30),

OBJECT_NAME VARCHAR2(30),

SUBOBJECT_NAME VARCHAR2(30),

OBJECT_ID NUMBER,

DATA_OBJECT_ID NUMBER,

OBJECT_TYPE VARCHAR2(19),

CREATED DATE,

LAST_DDL_TIME DATE,

TIMESTAMP VARCHAR2(19),

STATUS VARCHAR2(7),

TEMPORARY VARCHAR2(1),

GENERATED VARCHAR2(1),

SECONDARY VARCHAR2(1)

)

organization external

(type oracle_loader

default directory tmp

location( 'EXTERNALTEST.DAT' )

)

SQL> select * from SYSTEM.EXTERNAL_LOAD_TESTER

2  where rownum<2;

select * from SYSTEM.EXTERNAL_LOAD_TESTER

*

第 1 行出现错误:

ORA-29913: 执行 ODCIEXTTABLEFETCH 调出时出错

ORA-29400: 数据插件错误KUP-04020: found record longer than buffer size

supported, 524288, in C:\EXTERNALTEST.DAT

ORA-06512: 在 "SYS.ORACLE_LOADER", line 52

但是我通过oracle_datapump方式建立就没有问题。

create table external_load_tester

( OWNER VARCHAR2(30),

OBJECT_NAME VARCHAR2(30),

SUBOBJECT_NAME VARCHAR2(30),

OBJECT_ID NUMBER,

DATA_OBJECT_ID NUMBER,

OBJECT_TYPE VARCHAR2(19),

CREATED DATE,

LAST_DDL_TIME DATE,

TIMESTAMP VARCHAR2(19),

STATUS VARCHAR2(7),

TEMPORARY VARCHAR2(1),

GENERATED VARCHAR2(1),

SECONDARY VARCHAR2(1)

)

organization external

(type oracle_datapump

default directory tmp

location( 'EXTERNALTEST.DAT' )

)

SQL> select * from system.EXTERNAL_LOAD_TEST

2  where rownum<2;

OWNER                          OBJECT_NAME

------------------------------ ------------------------------

SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE

------------------------------ ---------- -------------- -------------------

CREATED        LAST_DDL_TIME  TIMESTAMP           STATUS  T G S

-------------- -------------- ------------------- ------- - - -

SYS                            ICOL$

20              2 TABLE

30-8月 -05     30-8月 -05     2005-08-30:13:50:24 VALID   N N N

高手请麻烦指教一下，谢谢