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.

Discover more from grepOra

Subscribe now to keep reading and get access to the full archive.

Continue reading