My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2021

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"


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.