[hudsona]

La vai :

SELECT TABLE_NAME,CONSTRAINT_NAME,STATUS FROM
USER_CONSTRAINTS
WHERE
R_CONSTRAINT_NAME IN
(SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME=’table_name’);

Se quiser os nomes das colunas vai na USER_CONS_COLUMNS.