OracleTips,Tricks&Scripts

1.Topic:CompilingInvalidObjects:

Oracle8iandOracle9iprovidesascriptcalledutlrp.sqllocatedin$ORACLE_HOME/rdbms/adminwhichcanbeusedanytimetorecompileallexisitingPL/SQLmodules(procedure,functions,packages,triggers,types,andviews)inadatabase.

編譯無效的對象：

$ORACLE_HOME/rdbms/admin/utlrp.sql

或者

編譯指定的對象：

過程：

alterprocedureprocedure_namecompile;

函數：

alterfunctionfunction_namecompile;

包：

alterpackagepackage_namecompile;

包體:

alterpackagepackage_namecompilebody;