如何重新编译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;