兴化信息网
育儿
当前位置:首页 > 育儿

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

发布时间:2019-09-13 19:12:04 编辑:笔名

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;

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1514202

查看本文来源

中医能治疗脑梗吗
5个月宝宝咳嗽
糖尿病胃轻瘫便秘能吃啥药
小儿积食什么原因