My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2020

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 <"SCHEMANAME">.<"TABLENAME"> SET "TYPE" = :a1,"COL1" = :a2,"STATUS" = :a3,"ACTIVATION_STATUS" = :a4,"PROV_STATUS" = :a5,"COL5" = :a6,"ERROR_MESSAGE" = :a7,"ORDER_ID" = :a8,"AUTO_>
Aborting transaction on /ggs/trail/eodsprd/ogg/se beginning at seqno 17 rba 25411005
                        error at seqno 17 rba 25411759
Problem replicating <SCHEMANAME>.<TABLENAME> to <SCHEMANAME>.<TABLENAME>
Mapping problem with compressed update record (target format)...
*
ID = 1872347
...
LAST_MODIFIED_DATE = 2012-05-20 00:00:41.793444000
*

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.