ORA-38029:object statistics are locked

错误：ORA-38029:object statistics are locked

场景：执行"analyze table table_name compute statistics;"

解决方式：

begin

dbms_stats.unlock_table_stats('USER_NAME','TABLE_NAME');

end;

参数介绍：

USER_NAME：schema

TABLE_NAME：表名