Script om alle constraints van een of meerdere tabellen te enablen

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

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

@enable_tab.sql