ORACLE BUG：dba_data_files视图不存在

现象：在测试库做实验的时候，想要查询dba_data_file视图，结果提示视图不存在。

过程：查询dba_data_file视图，系统提示视图不存在。查看实例状态，mount状态，将实例OPEN。重新查询，仍然失败！！

点击(此处)折叠或打开

1. SQL> desc dba_data_files;
   
2. ERROR:
   
3. ORA-04043: object dba_data_files does not exist
   
4. 
   
5. 
   
6. 
   
7. 
   
8. SQL>
   
9. SQL>
   
10. SQL> select status from v$instance;
    
11. 
    
12. 
    
13. STATUS
    
14. ------------
    
15. MOUNTED
    
16. 
    
17. 
    
18. SQL> alter database open;
    
19. 
    
20. 
    
21. Database altered.
    
22. 
    
23. 
    
24. SQL> select * from dba_data_files
    
25.   2 ;
    
26. select * from dba_data_files
    
27.               *
    
28. ERROR at line 1:
    
29. ORA-00942: table or view does not exist

官方描述：
     
     BUG影响的版本： Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.1 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.

   BUG描述： If you describe any DBA_* Views (Data dictionary views) in a mount stage, than you will not be able to  describe those views even after opening the database.

   解决方法：

    Available workarounds are:

    1) Don't describe the dba_* views at mount stage.

    OR

    2) If you issue DESC of any DBA_*views at mount stage, then shutdown and restart the DB instance.

    OR

    3) Flush the shared pool.

        SQL> Alter system flush shared_pool;

        and then reissue the failing command.

参考：
    http://www.linuxidc.com/Linux/2014-05/102006.htm
     MOS 文档ID 296235.1 文档 ID 296235.1

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

转载于:http://blog.itpub.net/31142205/viewspace-2113376/