Replication Server and Replication Agent impose the following constraints on Oracle datatypes:
Oracle BLOB, CLOB, NCLOB, and BFILE datatypes that contain more than 2GB will be truncated to 2GB.
If you use a version of Replication Server prior to version 12.5:
CHAR, RAW, ROWID, and VARCHAR2 datatypes that contain more than 255 bytes will be truncated to 255 bytes.
Oracle NCHAR and NVARCHAR2 multi-byte character datatypes will be replicated as char or varchar single-byte datatypes.
Oracle NUMBER datatype in the integer representation:
The corresponding Replication Server 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 maximum are rejected by Replication Server.
Oracle NUMBER datatype in the floating point representation:
The precision has the same limitations in range 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 acceptable to Replication Server. No loss of precision or scale occurs.
Replication Server Reference Manual for more information on replication definitions and the create replication definition command.
