My Oracle Support Banner

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

Last updated on JUNE 05, 2019

Applies to:

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


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" ("FECHA_PROG","COD_AGENTE","COD_UNIDAD","COD_UFI","VERSION","PERIODO_MINUTO_INI","PERIODO_MINUTO_FIN","HORA","TIPO_LIMITACION","FECHA_PUB"
,"DESCRIPCION","POT_LIMITE","FECHA_ACT","USUARIO_ACT") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13).


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


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

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