📋Steps in this guide1/1

Find dependents of an object

select * from dba_dependencies where owner='&SCHEMA_NAME' and name='&OBJECT_NAME'; select * from dba_dependencies where referenced_owner = 'USER_NAME' and referenced_name = 'OBJECT_NAME';

oracle configurationintermediate

by OracleDba

13 views

Find dependents of an object

Code/Command (click line numbers to comment):

1
2

select * from dba_dependencies where owner='&SCHEMA_NAME' and name='&OBJECT_NAME';
select * from dba_dependencies where referenced_owner = 'USER_NAME' and referenced_name = 'OBJECT_NAME';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!