Re: Recompile invalid packages

From: nobody <nobody_at_nowhere.com>
Date: Wed, 05 Nov 2003 15:58:16 GMT
Message-ID: <s69qb.29421$152.5977@news01.bloor.is.net.cable.rogers.com>

rem change the spool path to whatever you want

spool /opt/oracle/admin/adhoc/runthem.sql SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
/

spool off;

@/opt/oracle/admin/adhoc/runthem.sql

P.S. Why am I unemployed ?

"Julien" <chatlumo-nospam-_at_hotmail.com> wrote in message news:bob61u$2cta$1_at_news6.isdnet.net...
> 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.
>
>
Received on Wed Nov 05 2003 - 09:58:16 CST