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

最新推荐文章于 2024-01-16 12:39:08 发布

转载

最新推荐文章于 2024-01-16 12:39:08 发布 · 1.3k 阅读

文章标签：

#oracle kup04040

当执行 DBMS_STATS 时，可能会遇到 ORA-20011, ORA-29913 和 ORA-29400 错误，通常与外部表 ODCIEXTTABLEOPEN 调用失败有关。这些问题可能是由于外部表不存在或者临时 DataPump 外部表没有正确清理导致。解决方案包括清理孤儿 DataPump 作业、删除临时外部表或锁定统计表。" 102988395,8259838,SpringBoot整合MongoDB实战指南,"['SpringBoot开发', '数据库集成', 'MongoDB集成', 'NoSQL', 'Java开发']

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

后台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 failed:OR

最低0.47元/天解锁文章

200万优质内容无限畅学