If you would like to quickly find all Invalid Objects, including broken views in your database, you can use the following query:

SELECT owner,object_name,subobject_name,object_type FROM all_objects WHERE status='INVALID'

If you would like to exclude the HVW, DVW, and UVWs that are no longer maintained by NatureServe, you can use the following query:

SELECT owner,object_name,subobject_name,object_type FROM all_objects WHERE status='INVALID' and object_name not like '%UVW' and object_name not like '%DVW' and object_name not like '%HVW' AND OWNER='HDMS' order by OBJECT_TYPE, OBJECT_NAME;

SELECT count(*) FROM all_objects WHERE status='INVALID' and object_name not like '%UVW' and object_name not like '%DVW' and object_name not like '%HVW' AND OWNER='HDMS' order by OBJECT_TYPE, OBJECT_NAME;

SELECT count(*) FROM all_objects WHERE status='INVALID' AND OWNER='HDMS';