Utl_recomp

Oracle Recompile Invalid Objects with utlrp.sql Purpose Recompiling invalid objects is a routine job that follows an upgrade or a patch. You run one Oracle-supplied script, and the database works through every invalid object, so users do not meet them one by one. The script is utlrp.sql. It lives in the …