ORA-38029: object statistics are locked

SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;

ORA-38029:object statistics are locked

要运行一个dbms包才能解开
SQL>begin         
  2  dbms_stats.unlock_table_stats('TODAY','YGZHOU');
  3  end;
  4  /

SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;

Table analyzed.

锁统计信息时可以类似这样
BEGIN
  DBMS_STATS.DELETE_TABLE_STATS('OE','ORDERS');
  DBMS_STATS.LOCK_TABLE_STATS('OE','ORDERS');
END;
/

SQL>BEGIN

DBMS_

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24867586/viewspace-712204/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24867586/viewspace-712204/