导航
导航

编译无效对象

1、PL/SQL Developer,登录后点击compile invalid objects按钮,点击运行;
2、运行oracle目录下的utlrp.sql

可通过命令查询无效对象:

1
select object_name from user_objects where status='INVALID'

参考:
http://johnlxj.blog.163.com/blog/static/16586556420144445124767