【Case】ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP

一、報錯資訊

Errors in file /oracle/product/diag/rdbms/myhj/MyHJ/trace/MyHJ_j003_31396.trc:
ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges

二、原因解析

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. 

三、解決方法

You can ignore this error due to following:

  (1)The error is non-critical.

  (2)Other objects won't be affected by this error and gather stats job continues safely on other user objects. The error will not result in the termination of the gather stats job for the rest of the tables.

  (3)The message in the alert log is only informative.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30776559/viewspace-2151867/，如需轉載，請註明出處，否則將追究法律責任。