ORA-20000: Insufficient privileges to analyze an object in Dictionary Schema
While starting
"exec dbms_stats.gather_dictionary_stats;" as SYSDBA
i get back this Error stack:
ERROR at line 1:
ORA-20000: Insufficient privileges to analyze an object in Dictionary Schema
ORA-06512: at "SYS.DBMS_STATS", line 26903
ORA-06512: at "SYS.DBMS_STATS", line 26928
ORA-06512: at line 1
In the alert log i found the same message from the GATHER_STATS_JOB.
The table which wiil not be analyzed is SYS.DEPENDENCY$.
I tried it manually as SYSDBA but the same results:
ERROR at line 1:
ORA-20000: Unable to analyze TABLE "SYS"."DEPENDENCY$", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 23442