-- Oracle Find which table and which column does this Constraint refer to
SELECT table_name,constraint_name,column_name 
FROM user_cons_columns 
WHERE constraint_name like '%FK_CATNEWSLETTER%'