[Dica] OBJSTATUS - Status dos Objetos

[dr_gori]

Muito util quando se altera a estrutura de alguma tabela e um monte de objetos acaba ficando inválido...

Selecionar tudo

SET show off ver off echo off
accept vowner prompt "Pesquisar objetos do owner like (Def %):  " DEF %

column owner_obj format a40
select --owner||'-'||object_name owner_obj,
       'alter '||rtrim(object_type,'BODY')||' '||object_name||' compile;' compilar,
       '@C:\local_dos_fontes\'||object_name||'.SQL' recriar, 
       object_type, status, to_char(last_ddl_time,'dd/mm/rr-hh24:mi') last_ddl
from all_objects
where owner like upper('&vowner') and
      status<>'VALID'
order by owner, object_name;
set feedback on
set ver on