Database Administration (MOSC)

MOSC Banner

Discussions

Invalid Objects in sys and system schema

edited Jan 30, 2014 7:15AM in Database Administration (MOSC) 9 commentsAnswered
We want to upgrade one of our database (data warehouse) from Oracle 10.2.0.4.0 to 11gR2 (11.2.0.3.0). However, there are 2 invalid objects (UTL_RECOMP, DBMS_SQLPA) in system and sys schema respectively. I tried to recompile invalid objects using @utlrp.sq

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center