Oracle: Find tables referring to another

select table_name, constraint_name, status, owner
from all_constraints
where
r_constraint_name in
(–get primary and unique constraints on the target table. These can be used for FK references by other tables
select constraint_name from all_constraints
where constraint_type in (‘P’, ‘U’)
and table_name = ‘TABLE_NAME’
and owner = ‘SCHEMA’
)
order by table_name, constraint_name