重新編譯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=

From:http://tw.wingwit.com/Article/program/Oracle/201311/16966.html