[Solved] ORACLE 11g ORA-20000: Unable to analyze TABLE “AA”.”CMP3$87651″, insufficient…

Begin automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK”
End automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK”
Sat Sep 21 22:01:51 2019
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/test/test/trace/test_j000_24672.trc:
ORA-20000: Unable to analyze TABLE “AA”.”CMP3$87651″, insufficient privileges or does not exist

[oracle@test trace]$ sqlplus/as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Sep 21 22:19:41 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

22:19:41 SYS@test(test)> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS,TEMPORARY from dba_objects where OBJECT_NAME=’CMP3$87651′;

no rows selected

22:19:43 SYS@test(test)>

 

Solution:

As you can see from some explanations on MOS, the table is a temporary one and will be deleted. And the Auto Optimize Statistics task may still think this table exists in the data dictionary when it is executed. But actually this table no longer exists.
So this error will occur. From the explanation on MOS. It does not affect the execution of the subsequent Job that optimizes statistical information.

Similar Posts: