ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no

RDBMS 11.2.0.1 

PLATFORM :AIX 6.1

在alertlog中发现ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no exist 告警。

告警具体内容为

gather_stats_job encountered errors.check the trace file.
errors in file XXX
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist 

其中trc文件的大概内容如下：

MODULE_NAME:DBMS_SCHEDULER
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist
gather_stats_job:gather_stats_job("XXX","XXX","",...)
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist

排查过程：

在MOS上查看错误信息，发现以下文章的内容和错误较类似，也提供了相关的思路。

Gather Schema Statistics Errors with APPS.EUL5_B<number> ORA-20000 Unable to analyze TABLE (文档 ID 1680854.1)

DBMS_STATS: GATHER_STATS_JOB encountered errors. ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges (文档 ID 1463793.1)

该MOS上关于该错误的一些解释

This issue matches Bug 9939773 which was closed as not a bug as explained by the following description:
"
The compression advisor creates intermediate tables (creates/drops tables DBMS_TABCOMP_TEMP_UNCMP). In case a GATHER_STATS_JOB is run at the same time , the table(s) will be in the list of tables to be analyzed. In case the table is automatically dropped by the compression advisory job before the GATHER_STATS_JOB has reached to that table in the list, the ORA-2000 will be hit. When DBMS_STATS finds it is no longer available, it writes to the alert log.This is no different from the case where a user table is dropped during a statistics gather. 
"

 These tables are summary tables which only exist when the Discoverer scheduled batch job to create the summaries is still running and will then be dropped.

另外，在查询DBMS_TABCOMP_TEMP_UNCMP这个表的时候，发现库中是没有这个表的。无论是查询dba_tables 还是desc表。都没有的。从MOS上的一些解释可以看到，该表为临时的表，会被删掉。而自动优化统计信息任务在执行的时候，可能数据字典中还认为存在这个表。但实际这个表已经不存在了。所以会出现这个错误。从MOS上的解释看。不影响后续的优化统计信息的Job的执行。

END。

最后

以上就是迷你裙子为你收集整理的ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no的全部内容，希望文章能够帮你解决ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。