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;