[20140807]ORA-04043.txt

[20140807]ORA-04043.txt

SYS@test> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2228784 bytes
Variable Size            1006636496 bytes
Database Buffers          587202560 bytes
Redo Buffers                7344128 bytes
Database mounted.

SYS@test> @ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SYS@test> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

SYS@test> alter database open;
Database altered.

SYS@test> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

 

$ oerr ora 4043
04043, 00000, "object %s does not exist"
// *Cause:  An object name was specified that was not recognized by the system.
//          There are several possible causes:
//          - An invalid name for a table, view, sequence, procedure, function,
//          package, or package body was entered. Since the system could not
//          recognize the invalid name, it responded with the message that the
//          named object does not exist.
//          - An attempt was made to rename an index or a cluster, or some
//          other object that cannot be renamed.
// *Action: Check the spelling of the named object and rerun the code. (Valid
//          names of tables, views, functions, etc. can be listed by querying
//          the data dictionary.)

 

SYS@test> select count(*) from dba_views;
select count(*) from dba_views
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

SYS@test> select count(*) from user_views;
  COUNT(*)
----------
      4800

SYS@test> alter system flush SHARED_POOL;
System altered.

SYS@test> select count(*) from dba_views;
  COUNT(*)
----------
      6241

SYS@test> @desc dba_views;
Name                    Null?    Type
----------------------- -------- ----------------
OWNER                   NOT NULL VARCHAR2(30)
VIEW_NAME               NOT NULL VARCHAR2(30)
TEXT_LENGTH                      NUMBER
TEXT                             LONG
TYPE_TEXT_LENGTH                 NUMBER
TYPE_TEXT                        VARCHAR2(4000)
OID_TEXT_LENGTH                  NUMBER
OID_TEXT                         VARCHAR2(4000)
VIEW_TYPE_OWNER                  VARCHAR2(30)
VIEW_TYPE                        VARCHAR2(30)
SUPERVIEW_NAME                   VARCHAR2(30)
EDITIONING_VIEW                  VARCHAR2(1)
READ_ONLY                        VARCHAR2(1)

--如果在mount状态，看desc dual呢?
SYS@test> desc dual
ERROR:
ORA-04043: object dual does not exist

SYS@test> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00942: table or view does not exist
Process ID: 14360
Session ID: 5 Serial number: 3

--实例直接崩溃。

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

转载于:http://blog.itpub.net/267265/viewspace-1246984/