2.160 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.