To find the table that a constraint is in, you can do:

SELECT *
FROM all_constraints
WHERE constraint_name = ‘the_constraint_name’

This is useful for finding child table(s) that have dependent data when you can’t delete a row that has a parent.