set termout off pages 0 feedback off lines 132
spool temp.tmp
prompt spool enacon1.log
select 'alter table '||a.table_name||' enable constraint '||a.constraint_name||
chr(10)||'using index tablespace '||nvl(b.TABLESPACE_NAME,'utilbill_index')||';'
from user_constraints A, USER_INDEXES B
where a.status = 'DISABLED'
and b.index_name (+) = a.constraint_name
/
spool off
@temp.tmp
set termout off pages 0 feedback off
spool temp.tmp
prompt spool enacon2.log
select 'alter table '||a.table_name||' enable constraint '||a.constraint_name||
chr(10)||'using index tablespace '||nvl(b.TABLESPACE_NAME,'utilbill_index')||';'
from user_constraints A, USER_INDEXES B
where a.status = 'DISABLED'
and b.index_name (+) = a.constraint_name
/
spool off
@temp.tmp
set termout off pages 0 feedback off
spool temp.tmp
prompt spool enacon3.log
select 'alter table '||a.table_name||' enable constraint '||a.constraint_name||
chr(10)||'using index tablespace '||nvl(b.TABLESPACE_NAME,'utilbill_index')||';'
from user_constraints A, USER_INDEXES B
where a.status = 'DISABLED'
and b.index_name (+) = a.constraint_name
/
spool off
@temp.tmp
spool off
set termout on feedback on echo on pages 66