plsql:重新编译PLSQL中的无效对象或者指定的对象 的思路方法来源: 发布时间:星期三, 2008年12月24日 浏览:33次 评论:0
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; 0
相关文章
读者评论发表评论 |