Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recompile invalid packages
In addition to the other fine answers, also look at
ORACLE_HOME/rdbms/admin/utlirp.sql to recompile all invalid objects.
HTH,
Brian
Julien wrote:
>
> Hi,
>
> Do you know how can i recompile invalid package on SQL+ ?
>
> So, i know to do this on Toad but i need a command for SQL+
>
> Thanks,
> Julien.
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Nov 05 2003 - 10:18:49 CST