fvanboven_at_gmail.com wrote:
> Is there a way to recompile all invalid objects in PL/SQL??
>
> Currently we use the build-in functionality of PL/SQL Developer to
> recompile all invalid object after a database update.
>
> But I would like to add this to the end of our update script so the
> database is completely up to date in a single execution batch....
>
> Hope someone knows how to do this.
>
> Greetz,
>
> Frank van Boven
>
Apart from all the good examples, do you realize Oracle will
recompile on an 'as needed' base?
So, unless you're not sure weather everything actually will
compile, there is no reason to.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Dec 07 2005 - 08:23:21 CST
