Replaces invalid numeric ASCII data with an alternate value.
Syntax
-R value
Must be upper case.
value
The replacement value. The default is to replace with 0. Specify one of the following alternate values:
number
Replaces invalid data with the specified number.
NULL
Replaces invalid data with NULL
if the target column accepts NULL
values. Otherwise, replaces with 0
.
UNPRINTABLE
Rejects any column with unprintable data. The process stops and reports the bad value.
NONE
Does not replace numeric data. Oracle GoldenGate attempts to replicate the data as-is.