Query DBA_CONSTRAINTS where constraint_type='R' additionally you can query DBA_CONS_COLUMNS to get the required info.