Re: upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- 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?)
hth,
Martin
On Wed, Jul 13, 2011 at 09:16, Howard Latham <howard.latham@xxxxxxxxx> wrote:
> this is after several runs of utlrp
>
> On 13 July 2011 01:24, Ram Srinivasan <srinivasanram2004@xxxxxxxxx> wrote:
>>
>> Howard:
>> 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
>> ==============
--
//www.freelists.org/webpage/oracle-l
Other related posts:
