1、创建sql脚本文件
批量停用外键文件dis.sql
set echo off;
set feedback off;
set heading off;
set pagesize 0;
set termout off;
set timing off;
set trimout on;
set trimspool on;
set linesize 500;
set long 20000;
spool 'e:\text_log.sql'
select 'alter table '|| t.table_name||' disable constraint '||t.constraint_name||';'
from user_constraints t where t.constraint_type = 'R'
order by t.table_name;
spool off;
@ e:\text_log.sql;
set echo on;
批量启用外键文件en.sql
set echo off;
set feedback off;
set heading off;
set pagesize 0;
set termout off;
set timing off;
set trimout on;
set trimspool on;
set linesize 500;
set long 20000;
spool 'e:\text_log.sql'
select 'alter table '|| t.table_name||' enable constraint '||t.constraint_name||';&#