Take this as an additional hint:select t1.owner, t1.table_name, t1.constraint_name, t1.column_name, t1.position, t3.table_name parent_table, t3.column_name parent_column from user_cons_columns t1, user_constraints t2, user_cons_columns t3, user_constraints t4 where t1.table_name = t2.table_name and t1.constraint_name = t2.constraint_name and t1.owner = t2.owner and t2.CONSTRAINT_TYPE = 'R' and t4.constraint_type = 'P' and t4.constraint_name = t2.r_constraint_name and t4.OWNER = t2.R_OWNER and t4.table_name = t3.table_name and t4.CONSTRAINT_NAME = t3.CONSTRAINT_NAME and t4.owner = t3.owner and t1.position = t3.position order by t1.table_name, t1.constraint_name, t1.position
This query gives the columns involved in a referential integrity constraint in both tables. Is a bit time consuming but helps in case the column_names in both parent and children differ.
Hope this helps
-- (March 31, 2005) on Reverse Engineering a Data Model