find invalid object dependencies

SELECT owner, object_type, object_name, object_id, status
FROM SYS.dba_objects
WHERE object_id IN (
SELECT object_id
FROM public_dependency
CONNECT BY PRIOR object_id = referenced_object_id
START WITH referenced_object_id =
(SELECT object_id
FROM SYS.dba_objects
WHERE owner = :owner
AND object_name = :NAME
AND object_type = :TYPE))

Hiç yorum yok: