奇怪的ORA-04043错误及解决方法

显示全部楼层 · 2011-11-1 16:21:15

这个是偶然中遇到了一个奇怪错误，以前没有在意过，贴出来同大家分享：http://www.oracleonlinux.cn/2012/03/resolve-ora-04043/
附件阅读：

OracleOnLinux-ORA-04043.pdf(113.78 KB, 下载次数: 38)2012-3-29 14:58 上传点击文件名下载附件

千问 · 2011-11-1 16:21:15

呵呵，实验了一小把，还真是这样，以前都没有注意过。

千问 · 2011-11-1 16:21:15

在9i中表现有点不一样，当库open以后

千问 · 2011-11-1 16:21:15

xifenfei 发表于 2012-3-29 17:17
在9i中表现有点不一样，当库open以后
呵呵，手上没有9i的环境，9i表现啥样，能否帖出来瞅瞅，^_^

千问 · 2011-11-1 16:21:15

启动数据库到mount状态查询表
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area353441008 bytes
Fixed Size
451824 bytes
Variable Size
184549376 bytes
Database Buffers
167772160 bytes
Redo Buffers
667648 bytes
Database mounted.
SQL> desc dba_tables;
ERROR:
ORA-04043: object dba_tables does not exist

SQL> desc sys_xifenfei
ERROR:
ORA-04043: object sys_xifenfei does not exist

SQL> desc chf.chf_xifenfei
ERROR:
ORA-04043: object chf.chf_xifenfei does not exist
打开数据库查询
SQL> alter database open;

Database altered.

SQL> select count(*) from sys_xifenfei;
select count(*) from sys_xifenfei

*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select count(*) from chf.chf_xifenfei;

COUNT(*)
----------
868

SQL> select count(*) from dba_tables;
select count(*) from dba_tables

*
ERROR at line 1:
ORA-00942: table or view does not exist

open之后提示是ORA-00942

千问 · 2011-11-1 16:21:15

确实哎