How to find dependent objects in Oracle?
SELECT A.OWNER||'.'||A.NAME DEPENDENT_OBJECTS
FROM
(
SELECT
*
FROM
DBA_DEPENDENCIES
) A
START WITH REFERENCED_NAME = :OBJECT_NAME
CONNECT BY NOCYCLE ((REFERENCED_NAME = PRIOR NAME) AND (REFERENCED_OWNER = PRIOR OWNER))
No comments:
Post a Comment
Thanks for making a comment.