Error while query SYS.ALL_OBJECTS in SQL Developer
893279Oct 8 2011 — edited Oct 9 2011When I run the query[ select * from all_objects;] in sql developer with sys as sysdba in oracle 10g, it gives me an error
ORA-04045: errors during recompilation/revalidation of SYS.ALL_OBJECTS
ORA-06553: PLS-213: package STANDARD not accessible
04045. 00000 - "errors during recompilation/revalidation of %s.%s"
*Cause: This message indicates the object to which the following
errors apply. The errors occurred during implicit
recompilation/revalidation of the object.
*Action: Check the following errors for more information, and
make the necessary corrections to the object.
SQL> SELECT * from dba_objects where owner='SYS' and object_name='ALL_OBJECTS';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS
ALL_OBJECTS
2369 VIEW
22-OCT-05 09-OCT-11 2005-10-22:21:45:28 VALID N N N
SQL> select owner, object_name, object_type, status from dba_objects where object_name='STANDARD';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SYS
STANDARD
PACKAGE VALID
SYS
STANDARD
PACKAGE BODY VALID
Those I found are valid. How to fix the object?
Any help?? Thanks.