oracle 过程、函数、视图检查

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');