oracle暂停启约束

暂停约束

select ‘alter table ‘||table_name||‘ disable constraint ‘||constraint_name||‘;‘ from user_constraints where constraint_type=‘R‘;

启用约束
select ‘alter table ‘||table_name||‘ enable constraint ‘||constraint_name||‘;‘ from user_constraints where constraint_type=‘R‘;

执行所有查询出来的sql语句

oracle暂停启约束

原文：http://www.cnblogs.com/junhuang/p/5870997.html