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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s