ORA-20005: object statistics are locked (stattype = ALL)
exec dbms_stats.gather_table_stats('TEST');
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: 在 "SYS.DBMS_STATS", line 13056
ORA-06512: 在 "SYS.DBMS_STATS", line 13076
ORA-06512: 在 line 2
這個提示告訴我們,這個表的統計計息被鎖定,不允許更新,這是Oracle 10g的一個新特性,允許我們鎖定某些物件的統計資訊
select * from USER_TAB_STATISTICS;--stattype_locked 為all
exec dbms_stats.unlock_schema_stats(ownname => 'test');===執行這個就正常了===
再次執行exec dbms_stats.gather_table_stats('TEST');--正常
原因是因為使用impdp 只匯入metadata_only 或(expdp的時候使用了contend=metadata_only)時
沒有使用 use exclude=(table_statistics,index_statistics)引起的
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: 在 "SYS.DBMS_STATS", line 13056
ORA-06512: 在 "SYS.DBMS_STATS", line 13076
ORA-06512: 在 line 2
這個提示告訴我們,這個表的統計計息被鎖定,不允許更新,這是Oracle 10g的一個新特性,允許我們鎖定某些物件的統計資訊
select * from USER_TAB_STATISTICS;--stattype_locked 為all
exec dbms_stats.unlock_schema_stats(ownname => 'test');===執行這個就正常了===
再次執行exec dbms_stats.gather_table_stats('TEST');--正常
原因是因為使用impdp 只匯入metadata_only 或(expdp的時候使用了contend=metadata_only)時
沒有使用 use exclude=(table_statistics,index_statistics)引起的
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28258625/viewspace-1440842/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-20005:object statistics are locked (stattype = ALL)Object
- ORA-20005: object statistics are lockedObject
- IMP ORA-20005: object statistics are locked(一)Object
- IMP ORA-20005: object statistics are locked(二)Object
- ORA-38029: object statistics are lockedObject
- oracle 由於impdp 引起的表統計資訊被鎖 ORA-20005: object statistics are lockedOracleObject
- oracle 由於impdp 引起的表統計資訊被鎖 ORA-20005: object statistics are lockedOracleObject
- 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列對分割槽鎖定顯示為空
- 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列對分割槽鎖定顯示為空的解決
- v$lockv和$locked_object的區別Object
- JavaScript Compact Object All In OneJavaScriptObject
- 學習動態效能表(八)-(3)-V$LOCKED_OBJECTObject
- JavaScript object array sort by string bug All In OneJavaScriptObject
- oracle鎖表問題處理 v$lock v$locked_objectOracleObject
- [20120103] alter session set statistics_level = all;Session
- Oracle動態效能檢視學習之v$lock & v$locked_objectOracleObject
- (轉)學習Oracle動態效能表-(3)V$LOCK,V$LOCKED_OBJECTOracleObject
- 關聯v$session,v$locked_object,dba_objects查出鎖死會話及物件SessionObject會話物件
- JVM原始碼分析之Object.wait/notify(All)完全解讀JVM原始碼ObjectAI
- A. Locked Calculator
- Lombok @Locked指南Lombok
- Database StatisticsDatabase
- DELETE STATISTICSdelete
- Statistics related viewView
- Time Model Statistics
- oracle之StatisticsOracle
- Import parameter: STATISTICSImport
- SELECT ... FOR UPDATE SKIP LOCKED;
- httpd dead but subsys lockedhttpd
- Saving Original Statistics and Gathering New Statistics
- SciTech-Mathematics-Probability+Statistics-7 Key Statistics Concepts
- ORA-20005的解決方法
- SciTech-Mathmatics-Probability+Statistics-VI-Statistics:Quantifing Uncertainty + Regression Analysis)AI
- How restore CBO statisticsREST
- Oracle Column Group StatisticsOracle
- Explain for the Statistics of Execution PlanAI
- [PT]Column Histogram StatisticsHistogram
- Statistics and Data Analysis for BioinformaticsORM