ORA-04043: object dba_data_files does not exist

在mount状态的时候,如果你desc dba_*数据字典,会报错:
SQL>select status from v$instance;

STATUS
————
MOUNTED

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

然后,即使你将数据库alter database open到open状态,还是会报同样的错误:
SQL>alter database open;

Database altered.

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

SQL>select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>desc dba_temp_files;
Name Null? Type
—————————————– ——– —————————-
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER

也就是说,只要你在mount状态下desct过某个dba视图,oracle就不认识它了,除非你重启数据库. ; ;

共有 0 条评论

Top