ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-20001 selecting from DBA_TAB_STATISTICS

ORA-20001 selecting from DBA_TAB_STATISTICS

原创 Linux操作系统 作者:zhouwf0726 时间:2019-06-06 07:00:06 0 删除 编辑
 
SQL> SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS;
SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS
                                                  *
ERROR at line 1:
ORA-20001: BIN$N5R12EQSEATGQKJAIQFV8G==$0 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 2082
ORA-06512: at "SYS.DBMS_STATS", line 2098
ORA-06512: at "SYS.DBMS_STATS", line 26789
ORA-06512: at line 1

SQL> SHOW USER
USER is "SYS"
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
SQL> SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS;
STA
---
NO
YES
 
 
发现一个类似bug(11.2.1和11.2.2都有补丁),不过碰到的这个问题没有去打补丁,purge回收站解决的 :
 
 
Bug 9930151 - ORA-20001 selecting from DBA_TAB_STATISTICS [ID 9930151.8]

  修改时间 09-FEB-2011     类型 PATCH     状态 PUBLISHED  

Bug 9930151  ORA-20001 selecting from DBA_TAB_STATISTICS

 This note gives a brief overview of bug 9930151.
 The content was last updated on: 07-FEB-2011
 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.

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

请登录后发表评论 登录
全部评论

注册时间:2006-02-22

  • 博文量
    458
  • 访问量
    347410