Replicat fails with "OCI Error ORA-14402: updating partition key column would cause a partition change" (Doc ID 1461706.1)

Last updated on NOVEMBER 26, 2013

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Replicat fails with following error

OCI Error ORA-14402: updating partition key column would cause a partition change (status = 14402), SQL <UPDATE "SIKFE"."ACT_BPM_DEVICE" SET "TYPE" = :a1,"SERIAL_NUMBER" = :a2,"STATUS" = :a3,"ACTIVATION_STATUS" = :a4,"PROV_STATUS" = :a5,"OVERALL_HEALTH" = :a6,"ERROR_MESSAGE" = :a7,"ORDER_ID" = :a8,"AUTO_>
Aborting transaction on /ggs/trail/eodsprd/sik/sike/se beginning at seqno 17 rba 25411005
                        error at seqno 17 rba 25411759
Problem replicating ACT_BPM.DEVICE_MV to SIKFE.ACT_BPM_DEVICE
Mapping problem with compressed update record (target format)...
*
ID = 1872347
...
LAST_MODIFIED_DATE = 2012-05-20 00:00:41.793444000
*

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms