Re: Upgrading Oracle: utlrp.sql leaves 279 invalid objects

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Thu, 6 Mar 2003 20:57:53 -0000
Message-ID: <lDO9a.15107$EN3.122130@newsfep4-glfd.server.ntli.net>

"Don Seiler" <don_at_seiler.us> wrote in message news:94e86aed.0303061138.2e31488f_at_posting.google.com...
> I'm at the tail end of upgrading Oracle 7.3.4 to 9.2.0.1.
>
> Step 21 on the doc page says:
> ---
> Run utlrp.sql to recompile any remaining stored PL/SQL and Java code.
>
> SQL> @utlrp.sql
>
> Verify that all expected packages and classes are valid:
>
> SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
> SQL> SELECT destinct object_name FROM dba_objects WHERE
> status='INVALID';
> ---
>
> I don't get any errors from running utlrp.sql but the select
> statements show 279 invalid objects remaining. A great deal of them
> are KU$ views. The rest seem like Oracle-related items.
>
> Other than trying to manually recompile each item, is there something
> I can do to fix these? I've re-run utlrp.sql a couple of times but
> nothings changes.

thought you couldnt go directly from Oracle 7 to Oracle 9iR2? Received on Thu Mar 06 2003 - 14:57:53 CST