WARNING OGG-01154 SQL Error 14400 In Golden Gate With Partitioned Table (Doc ID 1561537.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

Replicat abended with error WARNING OGG-01154 SQL error 14400 in GoldenGate in partitioned table .
I dont have any record with partition key null in source.

2013-05-29 08:24:22  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repmera.prm:  SQL error 14400 mapping myowner.My_TABLE to myowner.My_TABLE
OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400). INSERT INTO "myowner"."My_TABLE"

Error: ORA-14400 (ORA-14400)
Text: inserted partition key does not map to any partition
---------------------------------------------------------------------------
Cause: An attempt was made to insert a record into, a Range or Composite
Range object, with a concatenated partition key that is beyond the
concatenated partition bound list of the last partition -OR- An
attempt was made to insert a record into a List object with a
partition key that did not match the literal values specified for
any of the partitions.
Action: Do not insert the key. Or, add a partition capable of accepting
the key, Or add values matching the key to a partition
specification

Changes

Cause

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