select df.owner as child_table_owner,
df.table_name as child_table_name,
df.constraint_name as referenced_constraint_name,
dc.owner as parent_table_owner,
dc.table_name as parent_table_name,
dc.constraint_name as parent_constraint_name
from all_constraints dc,
(select c.owner,
c.constraint_name,
c.r_constraint_name,
c.table_name
from all_constraints c
where 1=1
and constraint_type = 'R' ) df
where 1=1
and dc.constraint_name =df.r_constraint_name
and dc.owner not in ('SYSTEM', 'SYS', 'DBSNMP', 'EXFSYS',
'ORDDATA', 'CTXSYS', 'OLAPSYS', 'MDSYS', 'SYSMAN',
'DVSYS','APEX_040200', 'LBACSYS','FLOWS_FILES','GSMADMIN_INTERNAL' )
;
--整体外键引用关系
查询结果如下: