WEB开发网
开发学院数据库Oracle 重新编译PLSQL中无效对象或指定对象 阅读

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

 2008-12-17 13:06:37 来源:WEB开发网   
核心提示:Oracle Tips, Tricks & Scripts1. Topic: Compiling Invalid Objects:Oracle8i and Oracle9i provides a script called utlrp.sql located in $ORACLE_HOME/rdbms/admin wh

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; 

Tags:重新 编译 PLSQL

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接