SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = ‘INVALID’
AND object_name IN (SELECT referenced_name
FROM dba_dependencies
WHERE name = ‘<INVALID_OBJECT_NAME>’);

Recent Posts

Start typing and press Enter to search