Constraints - Tips

Para desativar ou ativar constraints, utilizo os comandos abaixo

--MONTA O COMANDO PARA DESABILITAR AS CONSTRAINTS DE APENAS UMA TABELA
select 'ALTER TABLE ' || owner || '."' || table_name ||
'" DISABLE CONSTRAINT '|| constraint_name || ';'
from
dba_constraints
where
table_name = '&nome_tabela'
order by owner,table_name
/

--MONTA COMANDO PARA DESABILITAR AS CONSTRAINTS DE UM SCHEMA
select 'ALTER TABLE ' || owner || '."' || table_name ||
'" DISABLE CONSTRAINT '|| constraint_name || ';'
from
dba_constraints
where
owner='MANOLO'
order by owner,table_name
/


Para checar a quantidade de constraints e quais estão ativas e inativas, uso esse select:

select owner,status, count(*) from dba_constraints group by owner,status
order by status

Boa semana a todos nos!!