Oracle Error 20005 Encountered
Contents |
upgrade, you do update stats at a couple of steps. Also, to support your PeopleSoft ora-20005 error instance, you do update stats at frequent interval. What update stats
How To Check If Table Stats Are Locked In Oracle
can cause is an error very similar to something like this: SQL Error. Error Position: 0
Dba_tab_statistics
Return: 20005 - ORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 23871 ORA-06512: at "SYS.DBMS_STATS", line 23922 ORA-06512: at line 1 RECSTATS
Ora-06512
PSTREEDEFNLANG LOW Error: SQL execute error for %UpdateStats(PSTREEDEFNLANG) Error: Import Record name PSTREEDEFNLANG Ended: Wed Apr 16 11:22:19 2014 Unsuccessful completion or Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 20005 - ORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 23871 ORA-06512: at "SYS.DBMS_STATS", line 23922 ORA-06512: at line 1 Failed SQL stmt: RECSTATS PS_VERTICAL_MARKET LOW (200,0) SQL Error. Error Position: 0 Return: 20005 - ORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 23871 ORA-06512: at "SYS.DBMS_STATS", line 23922 ORA-06512: at line 1 RECSTATS PS_VERTICAL_MARKET LOW Error: SQL execute error for %UpdateStats(PS_VERTICAL_MARKET) Error: Import Record name VERTICAL_MARKET Ended: Wed Apr 16 09:50:28 2014 Unsuccessful completion Resolution for ORA-20005: object statistics are locked (stattype = ALL) You may have more than one table in a schema which has object statistics locked, so your first intent should be to find all the tables which have update stats locked. Use the SQL select table_name, stattype_locked from dba_tab_statistics where owner = '
set import .'re The CDGH's objects into CDGH .. Importing table "AM_USER" 0 rows imported IMP-00017: ORACLE error 20005 due, the following statement fails: "BEGIN DBMS_STATS.SET_TABLE_STATS (NULL, '" AM_USER "', NULL, NULL, NULL, 0,0,0,6);" "END;" IMP-00003: ORACLE error 20005 encounteredORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 2058 ORA-06512: at "SYS.DBMS_STATS", line http://peoplesofttutorial.com/ora-20005-object-statistics-are-locked-stattype-all/ 2532 ORA-06512: at "SYS.DBMS_STATS", line 7489 ORA-06512: at line 1 IMP-00017: ORACLE error 20005 due, the following statement fails: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL: = NULL; SREC.MAXVAL: =" "NULL; SREC.EAVS: = 0; SREC.CHVALS: = NULL; SREC.NOVALS: = DBMS_STATS.NUMAR" "RAY (0,0); SREC.BKVALS: = DBMS_STATS.NUMARRAY (0,1); SREC.EPC: = http://oracle.veryoo.com/2013/07/imp-dmp-file-import-error-imp-00017.html 2; DBMS_STAT" "S.SET_COLUMN_STATS (NULL, '" AM_USER "', '" ID "', NULL, NULL, NULL, 0,0,0, srec, 0,6)" "; END;" IMP-00003: ORACLE error 20005 encounteredORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 2058 ORA-06512: at "SYS.DBMS_STATS", line 2532 ORA-06512: at "SYS.DBMS_STATS", line 6372 ORA-06512: at line 1 IMP-00017: ORACLE error 20005 due, the following statement fails: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL: = NULL; SREC.MAXVAL: =" "NULL; SREC.EAVS: = 0; SREC.CHVALS: = NULL; SREC.NOVALS: = DBMS_STATS.NUMAR" "RAY (0,0); SREC.BKVALS: = DBMS_STATS.NUMARRAY (0,1); SREC.EPC: = 2; DBMS_STAT" "S.SET_COLUMN_STATS (NULL, '" AM_USER "', '" USERID "', NULL, NULL, NULL, 0,0,0, srec," "0,6); END;" IMP-00003: ORACLE error 20005 encounteredORA-20005: object statistics are locked (stattype = ALL) ORA-06512: at "SYS.DBMS_STATS", line 2058 ORA-06512: at "SYS.DBMS_STATS", line 2532 ORA-06512: at "SYS.DBMS_STATS", line 6372 ORA-06512: at line 1 IMP-00017: ORACLE err
首页 | 博文目录 | 关于我 zhanglei_itput 博客访问: http://blog.itpub.net/9252210/viewspace-607376 945753 博文数量: 400 用 户 组: 普通用户 注册时间: 2009-02-10 11:45 个人简介 暂无介绍 文章分类 http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=26023&DestinationA=RSS 全部博文(400) oracle(198) 随笔(174) 主机(20) music(1) ITIL(1) MBA(6) 未分配的博文(0) 文章存档 2012年(5) 2012年11月(1) 2012年06月(1) oracle error 2012年02月(2) 2012年01月(1) 2011年(48) 2011年12月(1) 2011年09月(4) 2011年08月(3) 2011年07月(5) 2011年06月(2) 2011年05月(8) 2011年04月(6) 2011年03月(7) 2011年02月(4) 2011年01月(8) 2010年(130) 2010年12月(11) 2010年11月(6) 2010年10月(10) 2010年09月(10) 2010年08月(6) 2010年07月(5) 2010年06月(11) 2010年05月(20) 2010年04月(20) 2010年03月(10) oracle error 20005 2010年02月(11) 2010年01月(10) 2009年(217) 2009年12月(5) 2009年11月(20) 2009年10月(11) 2009年09月(8) 2009年08月(15) 2009年07月(21) 2009年06月(27) 2009年05月(32) 2009年04月(31) 2009年03月(36) 2009年02月(11) 我的朋友 lhrbest dawn009 海星星hk 最近访客 Dark_Kni rostolke kakaxi95 hd_syste dingli31 abin1703 q4184411 hzhv 清风艾艾 微信关注 IT168企业级官微 微信号:IT168qiye 系统架构师大会 微信号:SACC2013 订阅 推荐博文 ·Table ·Windows Server 2008完美安装... ·mysqlimport导入报错的排查... ·mysql数据库性能诊断 ·Oracle 12c Data Guard搭建(... 热词专题 IMP ORA-20005: object statistics are locked(二) 2009-06-24 09:37:22 分类: Linux
今天在做10.2.0.4数据库服务器上IMP的时候,由于特殊原因,需要先导入dmp1的表结构,然后在imp dmp2的数据,所以在imp的时候遇到一个问题: ORA-20005: object statistics are locked (stattype = ALL) 操作步骤如下:1. 导出ecc_view用