oracle kup04040,ORA-20011 ORA-29913 and ORA-29400错误的说明

后台alert报以下信息：

DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.

Errors in file /orahome/oracle/diag/rdbms/bims/bims/trace/bims_j000_11430.trc:

ORA-20011: Approximate NDV failed: ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错

ORA-29400: 数据插件错误error opening file /orahome/oracle/admin/bims/create/sh_sales_ext.log

关于这些错误，MOS文档ID 1274653.1有详细的说明，如下：

ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB (文档 ID 1274653.1)

类型:PROBLEM状态:PUBLISHED优先级:3

注释 (0)

APPLIES TO

Oracle Server - Standard Edition - Version 11.2.0.2 and later

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later

Oracle Server - Personal Edition - Version 11.2.0.2 and later

Information in this document applies to any platform.

SYMPTOMS

The key identifiers in these cases are typically the following:

DBMS_STATS is being executed in some form

ORA-20011, ORA-29913 and ORA-29400 Errors are seen, ORA-29913 specifying external function "ODCIEXTTABLEOPEN" signifying that there was an error in the callout by the external function "ODCIEXTTABLEOPEN " while trying to open an external table.

Some specific examples follow:

When attempting to run GATHER_STATS_JOB the following errors occur:

ORA-20011: Approximate NDV fa