重新编译PLSQL中无效对象或指定对象

Oracle Tips Tricks & Scripts

Topic: Compiling Invalid Objects:

Oraclei and Oraclei provides a script called utlrpsql located in $ORACLE_HOME/rdbms/admin which can be used anytime to recompile all exisiting PL/SQL modules (procedure functionspackagestriggers types and views) in a database

编译无效的对象

$ORACLE_HOME/rdbms/admin/utlrpsql

或者

编译指定的对象

过程

alter procedure procedure_name compile;

函数

alter function function_name compile;

包

alter package package_name compile;

包体:

alter package package_name compile body;

Trackback: x?PostId=