ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

最新推荐文章于 2022-01-27 14:52:32 发布

东方-phantom

最新推荐文章于 2022-01-27 14:52:32 发布

阅读量6.1k

点赞数

分类专栏： ORA-

本文链接：https://blog.youkuaiyun.com/hkyw000/article/details/12095403

版权

ORA- 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了解决Oracle数据库中ORA-20011错误的方法，该错误通常与外部表和数据泵作业相关。文章通过检查alert.log文件和外部表设置来定位问题，并最终通过删除遗留的监控导出表解决了这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错信息

ORA-20011:Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout.

1.首先检查alert.log.

ORA-20011: Approximate NDV failed: ORA-29913: error inexecuting ODCIEXTTABLEOPEN callout

KUP-11024: This external table can only be accessed fromwithin a Data Pump job.

*** 2013-09-26 22:00:06.240

DBMS_STATS: GATHER_STATS_JOB:GATHER_TABLE_STATS('"SYSTEM"','"ET$06A700050001"','""',...)

DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-29913:error in executing ODCIEXTTABLEOPEN callout

KUP-11024: This external table can only beaccessed from within a Data Pump job.

2.检查对应的外部表看看情况

SQL> select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME,ACCESS_TYPE from dba_external_tables;

OWNER TABLE_NAME DEFAULT_DIRECTORY_NAME ACCESS_

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

SYSTEM ET$06A700050001 DATA_PUMP_DIR CLOB

SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,status,to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created ,to_char(LAST_DDL_TIME, 'dd-mon-yyyy hh24:mi:ss') last_ddl_time from dba_objects where object_namelike 'ET$%';

OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED LAST_DDL_TIME

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

SYSTEM ET$06A700050001 TABLE VALID 12-dec-2012 04:53:48 12-dec-2012 04:53:48

这个原因是因为以前的一个系统监控export表没有被drop。

This error appear due to this table must be cleanup autowhen the datadump complete the job ,but it's not dropped as well so when gatherstatistics this error appear, so I drop the table.