Database Administration (MOSC)

MOSC Banner

ORA-20000: Insufficient privileges to analyze an object in Dictionary Schema

edited Sep 2, 2014 12:07PM in Database Administration (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center