/
Check for invalid objects

Check for invalid objects

This SQL query can be used to quickly check for invalid objects in our applications on development, acceptance or production.


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