Find dependents of an object - Oracle Database Script. 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';
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';