set echo off
--
--  disablefk.sql
--
--  Constraints - Disable all the foreign keys for the current user/schema login
--
--  Usage: @disablefk
--
set termout off
set verify off
set doc off
set feedback off
set recsep off
set pagesize 0
--
define lsize=133
set linesize &&lsize
--
define out_file=disablefk.ddl
spool &&out_file
--
select 'alter table '||owner||'.'||table_name||' disable constraint '
||constraint_name ||';'
from SYS.USER_CONSTRAINTS
where status = 'ENABLED' and constraint_type = 'R'
;
spool off
set doc off
set feedback on
set pagesize 30
set termout on
set echo on
start &&out_file
-- exit