Re: upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
Date: Sat, 16 Jul 2011 13:10:37 +0200
Maybe you want to check
http://blogs.oracle.com/UPGRADE/entry/database_registry_component_dependencies and decide which components you can remove.
Less objects might lead to less invalid objects? (and faster upgrade to 11.2 afterwards?)
On Wed, Jul 13, 2011 at 09:16, Howard Latham <howard.latham_at_gmail.com> wrote:
> this is after several runs of utlrp
> On 13 July 2011 01:24, Ram Srinivasan <srinivasanram2004_at_gmail.com> wrote:
>> Run the utlrp.sql from the $ORACLE_HOME/rdbms/admin/ directory. This
>> will recompile all the invalid objects. Check the invalid objects owned by
>> SYS, SYSTEM, and DBSNMP.
>> Ram Srinivasan