oracle 过程、函数、视图检查

原创于 2011-07-08 11:25:44 发布 · 172 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

oracle

本文提供了一段Oracle数据库的SQL脚本，用于找出所有者为'ORA'且状态为'INVALID'的对象，并尝试重新编译这些过程、视图和函数。此脚本适用于那些创建日期晚于2011年3月的对象。


select 'alter procedure ORA.'|| object_name || ' compile;' from dba_objects where owner = 'ORA' and object_type = 'PROCEDURE' and status = 'INVALID' and created > to_date('2011-03', 'yyyy-mm');
select 'alter view ORA.'|| object_name || ' compile;' from dba_objects where owner = 'ORA' and object_type = 'VIEW' and status = 'INVALID' and created > to_date('2011-03', 'yyyy-mm');
select 'alter function ORA.'|| object_name || ' compile;' from dba_objects where owner = 'ORA' and object_type = 'FUNCTION' and status = 'INVALID' and created > to_date('2011-03', 'yyyy-mm');

标签

#数据库