/
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'