如何成批设置某一用户下的表的外键约束为不可用 .txt

来自「oracle问题集」· 文本 代码 · 共 20 行

--如何成批设置某一用户下的表的外键约束为不可用
set echo off
set term off
set line 500
set pages 0
set feed off
spool dis_fk.sql
select 'alter table ' || table_name || ' modify constraint ' 
|| constraint_name || ' disable novalidate ; ' 
from user_constraints
where constraint_type = 'R' ;
spool off
set heading on
set term on
set line 80
set pages 24
set feed on
set echo on
@dis_fk.sql
spool off