查外键父子关系

select uc.constraint_name, uc.owner child_owner, uc.table_name child_table, ucc.column_name child_column
,ucp.owner parent_owner, ucp.table_name parent_table, ucp.column_name parent_column
from dba_constraints uc, dba_cons_columns ucc, dba_cons_columns ucp
where uc.owner = 'TRSDATA'
and uc.table_name = 'TABLEB'
and ucc.constraint_name = uc.constraint_name
and ucp.constraint_name = uc.r_constraint_name

 

注意，以上脚本运行很慢，可能需要拆散重写。

 

 

select 'alter table '||uc.owner||'.'||uc.table_name||' disable constraint '|| uc.constraint_name||';'
from dba_cons_columns ucp,  dba_constraints uc,dba_cons_columns ucc
where ucp.constraint_name = uc.r_constraint_name
and ucc.constraint_name = uc.constraint_name
and UCP.TABLE_NAME in ('CSPAFUNS',
'FBPACRPM',
'FBPACUSM',
'FBPADTCM',
'FBPAIMPM')

 

缩小范围可以快一点，可以拼disable constraint语句。