Timestamp datatype support for shareplex
Question on Functionality of Shareplex
The TIMESTAMP, TIMESTAMP WITH TIMEZONE, and TIMESTAMP WITH LOCAL TIMEZONE datatypes are supported for Oracle versions 9i and higher. Note the following:
1. For TIMESTAMP WITH TIME ZONE, the time zone is not changed by replication from a source machine in one time zone to a target machine in a different time zone. What this means is if, for example, the source machine is in the Pacific time zone and the target machine was in the Eastern time zone, the timestamp of the replicated data does not change from the timestamp of the source data.
2. For the TIMESTAMP WITH LOCAL TIMEZONE datatype, Oracle stores this data relative to the DB_TIME_ZONE. SharePlex adjusts the timestamp according to any difference in the DB_TIME_ZONE between the source and target machines. Users selecting data with identical session time zones fetch identical data from both the source and target.