Handling bad or invalid data in Replicat (Doc ID 1666655.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Goal

Replicat abends with invalid data error, such as ORA-01841 and how to replace known invalid data. In some instances Oracle database can contain invalid data that are captured and could not be replicated onto the target database. Or these captured data comes from a Non Oracle database that is valid in a source database but not valid in the target (heterogenous) database. For instance a date field can contain zero year, such as 0000-01-01 12:00 which if replicated onto a Oracle target will result in ORA-01841.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms