Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while trying to run DBMS_STAT.GATHER_TABLE_STATS

584396Mar 19 2009 — edited Mar 20 2009

Hi Gurus,

I am trying to run DBMS_STAT.GATHER_TABLE_STATS from a procedure from a DBA role granted user I am getting the folowing error:

ORA-20000: Unable to analyze TABLE "<SCHEMA_NAME>"."<TABLE_NAME>", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 13046
ORA-06512: at "SYS.DBMS_STATS", line 13076
ORA-06512: at line 2

Is I am missing something?

Please help...

//saby

This post has been answered by Tomasz K. on Mar 19 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2009

Added on Mar 19 2009

#general-database-discussions

15 comments

1,594 views