select c.owner, c.table_name
from dba_constraints c,
dba_constraints m
where c.constraint_type = 'R'
and m.constraint_name = c.r_constraint_name
and m.owner = 'OWNER_OF_MASTER_TABLE'
and m.table_name = 'MASTER_TABLE'