Re: Recompile invalid packages

"nobody" <nobody_at_nowhere.com> wrote in message news:<s69qb.29421$152.5977_at_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 ?

Because this doesn't cover all possible object compilations (think about one thing referencing another...)?

Because a modern dba would use a built-in sp?

Bonus consulting job: Demonstrate situation where built-in sp doesn't work.

Kyte-level: Demonstrate unpublished parameters to make it work.

Double-secret-probation-job: Prove Kyte wrong.

jg

--
@home.com is bogus.
http://images.amazon.com/images/P/B0000A02TZ.01.LZZZZZZZ.jpg