Recompilar Objetos inválidos

-- Quantidade de objetos inválidos.
-- Number of invalid objects.
set colsep   " | "
set linesize 100
set pagesize 500

SET LINESIZE 200 VERIFY OFF
COLUMN owner FORMAT A20
COLUMN object_name FORMAT A30
COLUMN edition_name FORMAT A15
select owner,object_type,count(*) qt
from dba_objects where status <> 'VALID'
group by owner,object_type order by owner;

-- Objetos inválidos.
-- Invalid objects.
set colsep   " | "
set linesize 100
set pagesize 500

SET LINESIZE 200 VERIFY OFF
COLUMN owner FORMAT A20
COLUMN object_name FORMAT A30
COLUMN edition_name FORMAT A15
select owner,object_type,object_name
from dba_objects where status <> 'VALID' --and owner='DBAPS'
group by owner,object_type,object_name order by owner;

-- Recompilar objetos inválidos.
-- Recompile invalid objects.
SQL > @?/rdbms/admin/utlrp.sql