How Will You Find Invalid Objects In Database ?

1.	How Will You Find Invalid Objects In Database ?
Answer» USING QUERY SQLPLUS select COUNT(*) from dba_objects where STATUS like 'INVALID'; using query SQLPLUS

Answer»

select COUNT(*) from dba_objects where STATUS like 'INVALID';

using query SQLPLUS

Discussion