Objetos invalidos en Oracle

set linesize 200
set pagesize 1000
col OBJECT_NAME format a50
select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects
where OWNER not in ('SYS','SYSTEM') and status = 'INVALID'
order by OWNER,OBJECT_TYPE,OBJECT_NAME;



para compilar todos

SQL> @Oracle_home/rdbms/admin/utlrp.sql