Handling bad or invalid data in Replicat
(Doc ID 1666655.1)
Last updated on MAY 29, 2018
Applies to:Oracle GoldenGate - Version 220.127.116.11.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!