Determinar Objetos invalidos
Aca un script para determinar los objetos invalidos de una instancia Oracle.-
select OWNER,
OBJECT_TYPE,
OBJECT_NAME,
STATUS
from dba_objects
where STATUS = 'INVALID'
order by OWNER, OBJECT_TYPE, OBJECT_NAME;
