Recompile all invalid objects using a single statement

[F. van Boven]

Hi,

I'd like to perform a "recompile invalid objects" after a database update.

What are the statements that PL/SL used to build the invalid objects list and recompile them? Or is there a procedure that does this for me?

I've located Oracle's "utlrp.sql" script, but I'd like a Stored Proc. But before making a Stored Procedure of it myself I would like to know if there already is a procedure, else compare it with the PL/SQL developer code...

 

[gulhaugen]

Hi

dbms_utility.compile_schema is availible.

Also see:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:637156098168

 

[F. van Boven]

This seems to completely compile the entire schema.

I'd like to compile only the invalid objects...

 

[rhalpain]

We are also interested in how this is done.