重新编译PLSQL中的无效对象或者指定的对象 的方法

Oracle Tips, Tricks & Scripts

1. Topic: Compiling Invalid Objects:

Oracle8i and Oracle9i provides a script called utlrp.sql located in $ORACLE_HOME/rdbms/admin which can be used anytime to recompile all exisiting PL/SQL modules (procedure, functions,packages,triggers, types, and views) in a database.

编译无效的对象：

$ORACLE_HOME/rdbms/admin/utlrp.sql

或者

编译指定的对象：

过程：

alter procedure procedure_name compile;

函数：

alter function function_name compile;

包：

alter package package_name compile;

包体:

alter package package_name compile body;