Script to find all invalid objects and recompile

Hi all,

Does anyone have a script that will go out and find all invalid objects and
recompile them. Every time I alter a package or DB object it marks its dependents status as 'INVALID' even though nothing done adversely affects the dependent object. I guess this is just a safeguard that Oracle
puts in. What I would really like is that every time I alter a package or
database object and compile it, a script would also compile its dependents
also.

I am using Oracle Enterprise 8.1.6 R2 on Linux.

Also does anyone know if Oracle 8.1.6 R3 comes with Enterprise Manager? Oracle claimed that they would bundle it with this release, but they've been
known to fib.

-Daniel N
Software System Engineer Received on Fri Dec 08 2000 - 10:04:31 CST