Re: Invalid Objects when Upgrading

amerar_at_iwc.net wrote:
> Hey All,
>
> We just (finally) applied patch 4163445, which is the 9.2.0.7 upgrade.
> Upon completing the upgrade, a few SYS objects became invalid and do
> not compile:
>
> DBMS_METADATA_UTIL
> DBMS_METADATA
> DBMS_LOGMNR_SESSION
> DBMS_INTERNAL_LOGSTDBY
> DBMS_EXPORT_EXTENSION
>
> Just wondering if these are serious, or worth our attention to fix
> whatever the problems are......
>
> Thanks in advance!
>

A lot of objects can become invalid after applying a patch or a patchset. It is always recommended to run @?/rdbms/admin/utlrp.sql after the patch or patchset. This will recompile any invalid objects.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown