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'
Комментариев нет:
Отправить комментарий