Handling bad or invalid data in Replicat
Last updated on MAY 29, 2018
Applies to:Oracle GoldenGate - Version 188.8.131.52.11 and later
Information in this document applies to any platform.
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.
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