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
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>’);