set pagesize 200
col tabela_filha format a20
col tabela_mae format a20
col Referencia format a20
col Chave_Primaria format a20
select a.table_name tabela_filha, a.constraint_name Referencia,
a.status, b.table_name tabela_mae, a.r_constraint_name Chave_Primaria
from user_constraints a, user_constraints b
where a.owner = b.owner and
a.r_constraint_name = b.constraint_name and
a.table_name = 'MIX0064'
union
select a.table_name tabela_filha, a.constraint_name Referencia,
a.status, b.table_name tabela_mae, a.r_constraint_name Chave_Primaria
from user_constraints a, user_constraints b
where a.owner = b.owner and
a.r_constraint_name = b.constraint_name and
b.table_name = 'MIX064';
Mas no ORACLE não funciona peço a ajuda de vocês.