Skip to Main Content

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!

ora-20005 object statistics are locked?

Guess2Dec 20 2007 — edited Oct 21 2009
I can analyze now, but last night I got this error. This is on a gather_table_stats.

any idea why this would happen? If I google it all I find is that this is a possible exception for dbms_stats and nothing about how to solve it.

ERROR at line 1:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 13182
ORA-06512: at "SYS.DBMS_STATS", line 13202
ORA-06512: at line 2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2009
Added on Dec 20 2007
17 comments
91,191 views