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

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Dec 20 2007

#general-database-discussions

17 comments

91,191 views