ORA-20000 as SYSDBA user...
Hi, there,
Anyone seen this issue? I'm running this on a system running RDBMS 11.2.0.2 BP7.
I'm gathering my dictionary stats as part of a scheduled job. The job is running as SYSDBA and bombs out with an ORA-20000 after about 24 hours (it's a big database, etc).
SQL> USER is "SYS"
SQL> BEGIN dbms_stats.gather_database_stats(estimate_percent=> null, method_opt => 'FOR ALL COLUMNS SIZE 1', degree => 8, granularity => 'AUTO', cascade => tr
ue); END;
*
ERROR at line 1:
ORA-20000: Insufficient privileges to analyze an object in Database
ORA-06512: at "SYS.DBMS_STATS", line 24098
ORA-06512: at "SYS.DBMS_STATS", line 24268
ORA-06512: at "SYS.DBMS_STATS", line 24224
ORA-06512: at line 1
Huh?