Replication Server and Replication Agent impose some constraints on the Oracle NUMBER datatype.
The corresponding Sybase int datatype has a smaller absolute maximum value.
The Oracle NUMBER absolute maximum value is 38 digits of precision, between 9.9 x 10125 and 1 x 10-130. The Sybase int value is between 231 - 1 and -231 (2,147,483,647 and -2,147,483,648), inclusive.
Oracle NUMBER values greater than the Sybase int maximum are rejected by Replication Server.
The precision of the floating point representation has the same range limitation as the integer representation.
If the floating point value is outside the Sybase range of 231 - 1 and -231 (2,147,483,647 and -2,147,483,648), Replication Agent for Oracle converts the number into exponential format to make it compatible with Replication Server. No loss of precision or scale occurs.
When a TIMESTAMP WITH TIME ZONE datatype is replicated, the time zone information is used to resolve the timestamp value to the “local” time zone and then the resolved value is replicated. (The time zone information itself is not replicated.)
For example, if a TIMESTAMP WITH TIME ZONE datatype is recorded in Oracle as “01-JAN-05 09:00:00.000000 AM -8:00” and the “local” time zone is -6:00, the replicated value is “01-JAN-05 11:00:00.000000”. The timestamp value is adjusted for the difference between the recorded time zone of -8:00 and the local time zone of -6:00, and the adjusted value is replicated.