Voltar
-
Título
[KEEPER] Update with CASE statement causing out of sync -
Descrição
When updating source table with CASE statement in such a way that one of the unique key column values are swapped between two existing rows, target table goes out of sync with unique constraint violation.
On source, oracle does not raise unique constraint violation as it is one update that changes both rows. On target, SharePlex post executes update statement for each row separately based on how it is written in redo log and it raises unique constraint violation.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.