熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

重新編譯PLSQL中無效對象或指定對象

2013-11-13 15:35:03  來源: Oracle 
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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.