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 (stattype = ALL)

Junior alertApr 15 2019 — edited Apr 15 2019

hello, community, I have the following error when trying to calculate statistics for a table!!,

I do not understand why I can not calculate the statistics, will it be a problem of privileges?

exec dbms_stats.gather_index_stats('mset', 'mset');

BEGIN dbms_stats.gather_index_stats('mset', 'mset'); END;

*
ERROR at line 1:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at “SYS.DBMS_STATS”, line 10640
ORA-06512: at “SYS.DBMS_STATS”, line 10664
ORA-06512: at line 1

Comments
Post Details
Added on Apr 15 2019
5 comments
1,305 views