Oracle Databaseの失敗したオブジェクトの処理の詳細

select owner, object_name, object_type, status from dba_objects t where status='INVALID' order by t.owner,t.object_type;

--automatically generate view recompile statement
select owner, object_name, object_type, status ,'alter view ' || t.owner||'.' || object_name || ' compile'||';'
from dba_objects t  
where status='INVALID' and t.object_type='VIEW' order by t.owner,t.object_type;
--automatically generate function recompile statements
select owner, object_name, object_type, status ,'alter FUNCTION ' || t.owner||'. || object_name || ' compile'||';'
from dba_objects t  
where status='INVALID' and t.object_type='FUNCTION' order by t.owner,t.object_type;
--automatically generate the visualization chart recompile statement
select owner, object_name, object_type, status ,'alter MATERIALIZED VIEW ' || t.owner||'. || object_name || ' compile'||';'
from dba_objects t  
where status='INVALID' and t.object_type='MATERIALIZED VIEW' order by t.owner,t.object_type;
--automatically generate package recompile statement
select owner, object_name, object_type, status ,'alter PACKAGE ' || t.owner||'. || object_name || ' compile'||';'
from dba_objects t  
where status='INVALID' and t.object_type='PACKAGE BODY' order by t.owner,t.object_type;
--automatically generate trigger recompile statement
select owner, object_name, object_type, status ,'alter TRIGGER ' || t.owner||'. || object_name || ' compile'||';'
from dba_objects t  
where status='INVALID' and t.object_type='TRIGGER' order by t.owner,t.object_type;