Upgrading Oracle: utlrp.sql leaves 279 invalid objects

From: Don Seiler <don_at_seiler.us>
Date: 6 Mar 2003 11:38:16 -0800
Message-ID: <94e86aed.0303061138.2e31488f@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. Received on Thu Mar 06 2003 - 13:38:16 CST