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!

Invalid objects in sys user

707021Jul 17 2009 — edited Jul 17 2009

Hi all,

I have lots of invalid objects in sys user. while trying to recompile i got the following error

ORA-20001: Cannot recompile SYS objects
ORA-06512: at "SYS.DBMS_UTILITY", line 321.
Then i tried to recompile it using sql>cd $ORACLE_HOME/rdbms/admin/ utlrp.sql and utlprp.sql but i didnt find any difference.
My database version is oracle10g. can any one help me for this.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2009

Added on Jul 17 2009

#general-database-discussions

2 comments

1,172 views