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/，如需轉載，請註明出處，否則將追究法律責任。