My Oracle Support Banner

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

Last updated on MAY 14, 2020

Applies to:

Oracle GoldenGate - Version 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.