пятница, 31 июля 2015 г.

How to disable and enable depended constraints

select
--'truncate table '|| TABLE_NAME || ';'
'alter table ' || TABLE_NAME || ' enable constraint ' || CONSTRAINT_NAME || ';'
from ALL_CONSTRAINTS
where CONSTRAINT_TYPE = 'R'
  and STATUS <> 'ENABLED'
  --and R_CONSTRAINT_NAME = 'C_MEDHISTCONS_PK'
order by TABLE_NAME

select 'alter table ' || TABLE_NAME || ' disable constraint ' || CONSTRAINT_NAME || ';'
from ALL_CONSTRAINTS
where CONSTRAINT_TYPE = 'R'
  and R_CONSTRAINT_NAME = 'C_DCSPECS_PK'  

Комментариев нет:

Отправить комментарий