Re: Invalid Objects when Upgrading

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 14 Jun 2006 14:04:27 GMT
Message-ID: <1150293866.494615@proxy.dienste.wien.at>

amerar_at_iwc.net <amerar_at_iwc.net> wrote:
> 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......

You can recompile the packages from sqlplus and type 'show error' to get the error messages. Maybe they help.

Yours,
Laurenz Albe Received on Wed Jun 14 2006 - 09:04:27 CDT