Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invaliad objects
select object_name from all_objects where status = 'INVALID';
You need to compile all those invalid objects. I've used sql to create sql...
This will do some overkill by compiling both the package body and spec for those specs that are invalid, but will compile the package bodies where the spec is valid.
You will need to run the compiles as the object owner or have enough explicit privileges on the objects and their referenced objects.
spool junk.sql
select 'alter ' || object_type || ' ' || object_name || ' compile;' where object_type <> 'PACKAGE BODY' and status = 'INVALID';
select 'alter package ' || object_name || ' compile body;' where object_type ='PACKAGE BODY' and status = 'INVALID';
spool off
@junk
Phil Cook
Certified Oracle DBA
JBHill62 <jbhill62_at_aol.com> wrote in article
<19980110182901.NAA19726_at_ladder01.news.aol.com>...
> I did a database upgrade recently I now have a bunch of invalid
> objects.
>
> How do I make this objects valiad once more?
>
>
Received on Sat Jan 10 1998 - 00:00:00 CST