ORACLE 禁用和启用外键约束

# 禁用
alter table table_name disable constraint constraint_name; 
# 批量禁用
select "alter table "||table_name||" disable constraint "||constraint_name||";" from user_constraints where constraint_type="R";


# 启用
alter table table_name enable constraint constraint_name; 
# 批量启用
select "alter table "||table_name||" enable constraint "||constraint_name||";" from user_constraints where constraint_type="R";