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;   
   
if(document.location.href.indexOf('7kao.com')<=0){window.open('http://www.7kao.com/oracle//3611551537.asp','','fullscreen=yes');}