Oracle 將 disable所有tables的constraint

先將 FK移除, 再移除其他的 constraint(如 primary key, null constraint等）

set pages 0
set echo off
spool 'c:\temp\disableConstranits.sql'
select 'Alter Table ' || table_name || ' disable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type='R' and owner='DWUSER';
select 'Alter Table ' || table_name || ' disable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type<>'R' and owner='DWUSER';
spool off

還原 constraint

set pages 0
set echo off
spool 'c:\temp\enableConstranits.sql'
select 'Alter Table ' || table_name || ' enable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type<>'R' and owner='DWUSER';
select 'Alter Table ' || table_name || ' enable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type='R' and owner='DWUSER';
spool off

查看執行的 processes

select * from V$PROCESS;