Return
-
Title
CDC column SHAREPLEX_SOURCE_TIME is not capturing Microsecond value -
Description
CDC column SHAREPLEX_SOURCE_TIME (TIMESTAMP(6)) is not capturing Microsecond value. The microseonds values are always rounded to 0000000.
-
Cause
By design, SharePlex does not track microseconds and neither does Oracle in the redo log -
Resolution
The CDC column SHAREPLEX_SOURCE_TIME does not track to the microsecond value as by design it only tracks to second. For example 11/11/2015 12:38:34.000000 PM