Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while query SYS.ALL_OBJECTS in SQL Developer

893279Oct 8 2011 — edited Oct 9 2011
When 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.
This post has been answered by 893278 on Oct 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2011
Added on Oct 8 2011
5 comments
1,894 views