Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invaliad objects
JBHill,
You could also use the DBMS_UTILITY package to do this.
DBMS_UTILITY.COMPILE_SCHEMA('<name_of_owner>');
This should compile all your objects and take care of dependencies.
Naresh.
InDfw wrote:
>
> 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 Sun Jan 11 1998 - 00:00:00 CST