select *
from all_constraints
where r_constraint_name in (
select constraint_name
from all_constraints
where table_name='TABLE_NAME'
);
Reference¶
https://stackoverflow.com/questions/1143728/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer