ITPub博客

首页 > 数据库 > Oracle > ORA-20001: ORA-06512: at "SYS.DBMS_STATS", line 2242

ORA-20001: ORA-06512: at "SYS.DBMS_STATS", line 2242

原创 Oracle 作者:parknkjun 时间:2015-08-26 00:28:20 0 删除 编辑
某客户数据库在执行查询select  * from  DBA_TAB_STATISTICS报如下错误:

ORA-20001: BIN$12EX+RAYNZZGQB4KEQF0BW==$0 is an invalid identifier

ORA-06512: at "SYS.DBMS_STATS", line 2242

ORA-06512: at "SYS.DBMS_STATS", line 2258

ORA-06512: at "SYS.DBMS_STATS", line 30041

ORA-06512: at line 1

查找MOS,确定为bug,客户数据库版本为11.2.0.2,该bug在11.2.0.3中修复

Bug 9930151  ORA-20001 selecting from DBA_TAB_STATISTICS
 This note gives a brief overview of bug 9930151. 
 The content was last updated on: 28-JUN-2013
 Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 12.1
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

ORA-20001 errors are possible when querying statistics data dictionary
views if table names have non-alphanumeric characters. 
This includes if objects are present in the recycle bin.
 
eg:
 SELECT STALE_STATS FROM DBA_TAB_STATISTICS WHERE TABLE_NAME = '/X/Y';
 ^
 ORA-20001: /X/Y is an invalid identifier
 ORA-06512: at "SYS.DBMS_STATS", line 2082
 ...
 
Rediscovery Notes:
 If you are using table names with non-alphanumeric characters, and
 querying the statistics dictionary views for these tables gives an
 ORA-20001 error you are probably hitting this bug.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

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

请登录后发表评论 登录
全部评论
DBA攻城狮

注册时间:2008-02-11

  • 博文量
    115
  • 访问量
    539209