Check for invalid objects

Owned by Noreen Dertinger
Jul 24, 2023
1 min read

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'