Script om de constraints van een of meerdere tabellen te disabelen

set termout off
set feedback off
set heading off
set pagesize 9999
set linesize 132

spool disable_tab.sql
select 'alter table '||owner||'.'||table_name||' disable constraint '||constraint_name||';'
from dba_constraints
where owner = 'MIKE'
and table_name IN (
'TAB1',
'TAB2',
'TAB3',
'TAB4')
/
spool off

@disable_tab.sql