set echo off
set feedback off
set linesize 2000
set pagesize 5000
set trim on
set trims on
set heading off
spool @cur_path/set_fk_disable.sql
select 'ALTER TABLE '||table_name||' DISABLE CONSTRAINT '||constraint_name||';' from user_constraints where constraint_type='R';
spool off
set echo on
quit;
fk设置为disable
最新推荐文章于 2021-04-04 02:17:49 发布