TCPSOURCETIMER | NOTCPSOURCETIMER
Valid For
Extract
Description
Use the TCPSOURCETIMER
and NOTCPSOURCETIMER
parameters to manage the timestamps of replicated operations for reporting purposes within the Oracle GoldenGate environment.
TCPSOURCETIMER
and NOTCPSOURCETIMER
are global parameters and apply to all TABLE
statements in the Extract parameter file.
Default
TCPSOURCETIMER
Syntax
TCPSOURCETIMER | NOTCPSOURCETIMER
-
TCPSOURCETIMER
-
Adjusts the timestamp of data records when they are sent to other systems, making it easier to interpret synchronization lag. This is the default.
-
NOTCPSOURCETIMER
-
Retains the original timestamp value. Use
NOTCPSOURCETIMER
when using timestamp-based conflict resolution in a bidirectional configuration and when using a user token that refers to'GGHEADER
','COMMITTIMESTAMP
' of the@GETENV
column-conversion function.