The following query will list objects that refer a table "TABLE_A" which belongs to a schema "SCHEMA_A"
select name,owner
from dba_dependencies
where referenced_name='TABLE_A'
and referenced_owner='SCHEMA_A'
Technical tid-bits and more ! Leave a comment if you found something useful.
select name,owner
from dba_dependencies
where referenced_name='TABLE_A'
and referenced_owner='SCHEMA_A'
No comments:
Post a Comment