GoldenGate abend with OCI Error ORA-14400: inserted partition key does not map to any partition

GoldenGate replicat issuing OGG-01296 Error mapping then abbending?

Review replicat report error.

GGSCI> view report rep01

If you found something like this below, you probably should review partition in target table

WARNING OGG-01004 Aborted grouped transaction on 'TARGET_OWNER.TOOL_SIZE', Database error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL ).
WARNING OGG-01154 SQL error 14400 mapping SOURCE_OWNER.TOOL_SIZE to TARGET_OWNER.NAIL_SIZE OCI Error ORA-14400: inserted partition key does not map to
ALTER TABLE TARGET_OWNER.NAIL_SIZE
ADD PARTITION SECTOR VALUES ('STEEL')
TABLESPACE STEEL_DATA;
GGSCI> start rep01

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.