Invalid Objects after Recent Patching
After a recent patch application, it is found that there are still a large number of Invalid Objects on the instance.
Executed following script to identify the invalids:
Executed following script to identify the invalids:
column owner format A9
column object_name format A31
column object_type format A15
column last_ddl_time format A10
spool invalids.lst
select OWNER, OBJECT_NAME,OBJECT_TYPE,STATUS,LAST_DDL_TIME
from dba_objects where status='INVALID'
order by owner;
Tagged:
0