- 删除所有外键约束
- Sql代码 复制代码
- select 'alter table '||table_name||' drop constraint '||constraint_name||';' from user_constraints where constraint_type='R'
- 禁用所有外键约束
- Sql代码
- select 'alter table '||table_name||' disable constraint '||constraint_name||';' from user_constraints where constraint_type='R'
- 启用所有外键约束
- Sql代码
- select 'alter table '||table_name||' enable constraint '||constraint_name||';' from user_constraints where constraint_type='R'
查询所有的约束
select * from user_constraints where constraint_name=upper('FK_CT_FEERU_REFERENCE_CT_BILLC')
select * from user_cons_columns where lower(column_name)='numimprateguid'
使此外键不可用
alter table ct_trunkg_ref_billc disable constraint FK_CT_TRUNK_REFERENCE_CT_BILLC;
使此外键可用
alter table ct_trunkg_ref_billc enable constraint FK_CT_TRUNK_REFERENCE_CT_BILLC;
- --ct_billcode与生产同步数据
- select * from user_constraints where constraint_name=upper('FK_CT_FEERU_REFERENCE_CT_BILLC')
- --第一步,停用引用-ct_billcode约束
- alter table ct_trunkg_ref_billc disable constraint FK_CT_TRUNK_REFERENCE_CT_BILLC;
- alter table CT_FEERULE disable constraint FK_CT_FEERU_REFERENCE_CT_BILLC;
- --第二步,删除原有数据,同步生关数据
- delete from ct_billcode
- insert into ct_billcode
- select * from ct_billcode@prod2
- --第三步,约束从新建立
- alter table ct_trunkg_ref_billc enable constraint FK_CT_TRUNK_REFERENCE_CT_BILLC;
- alter table CT_FEERULE enable constraint FK_CT_FEERU_REFERENCE_CT_BILLC;