How to find invalid objects with timestamp in oracle database.

 

Use below query to find the invalid objects with time stamp when they got invalidated.

select owner,object_name,timestamp, to_char(created,'hh24:mi:ss'), to_char(last_ddl_time,'hh24:mi:ss'),status from dba_objects 
where status = 'INVALID' 
and owner = 'APPS' 
order by timestamp;

Thanks for going through the post...............