Data Replication
- Data Replication 9.8.0 HotFix 3
- All Products
Oracle Source Datatype | Oracle Target Datatype | Comments |
---|---|---|
BINARY_DOUBLE | BINARY_DOUBLE | When replicating an 8-byte floating-point numeric value to a BINARY_DOUBLE column on the target, the Applier rounds this value and preserves only 15 digits after the decimal point by default. Use the apply.merge.double_precision runtime parameter to change the default precision value. |
BINARY_FLOAT | BINARY_FLOAT | When replicating an 8-byte floating-point numeric value to a BINARY_FLOAT column on the target, the Applier rounds this value and preserves only 15 digits after the decimal point by default. Use the apply.merge.double_precision runtime parameter to change the default precision value. |
BLOB | BLOB | By default, the Applier cannot insert change data into LOB and LONG columns if the total row data size exceeds 4000 bytes. In this case, set the apply.oracle.use_returning_into runtime parameter to 1 to configure the Applier to use the RETURNING INTO clause to insert change data into LOB and LONG columns. If the global.lob_truncation_size runtime parameter is set to 64000 bytes or less, InitialSync handles BLOB data as RAW data to improve performance. Oracle piecewise operations are supported for SQL Apply mode only. The Applier cannot load change data to Oracle LOB columns in Merge Apply mode. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
CHAR( n ) | CHAR( n' )
| - |
CLOB | CLOB | By default, the Applier cannot insert change data into LOB and LONG columns if the total row data size exceeds 4000 bytes. In this case, set the apply.oracle.use_returning_into runtime parameter to 1 to configure the Applier to use the RETURNING INTO clause to insert change data into LOB and LONG columns. Oracle piecewise operations are supported for SQL Apply mode only. The Applier cannot load change data to Oracle LOB columns in Merge Apply mode. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
DATE | DATE | - |
FLOAT( p ) | FLOAT( p ) | - |
INTERVAL DAY TO SECOND | INTERVAL DAY (%s) TO SECOND (%s) | - |
INTERVAL YEAR TO MONTH |
| - |
LONG | CLOB | By default, the Applier cannot insert change data into LOB and LONG columns if the total row data size exceeds 4000 bytes. In this case, set the apply.oracle.use_returning_into runtime parameter to 1 to configure the Applier to use the RETURNING INTO clause to insert change data into LOB and LONG columns. For Merge Apply mappings, map source columns with the LONG datatype to target columns with the VARCHAR(40000) datatype. LONG columns are not supported for materializing Oracle targets with DBLinks. Maximum supported size is 8 KB. Oracle piecewise operations are supported for SQL Apply mode only. |
LONG RAW | BLOB | By default, the Applier cannot insert change data into LOB and LONG columns if the total row data size exceeds 4000 bytes. In this case, set the apply.oracle.use_returning_into runtime parameter to 1 to configure the Applier to use the RETURNING INTO clause to insert change data into LOB and LONG columns. LONG RAW columns are not supported for materializing Oracle targets with DBLinks. Oracle piecewise operations are supported for SQL Apply mode only. The Applier cannot load change data to Oracle LOB columns in Merge Apply mode. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
NCHAR( n ) | NCHAR( n' )
| - |
NCLOB | NCLOB | By default, the Applier cannot insert change data into LOB and LONG columns if the total row data size exceeds 4000 bytes. In this case, set the apply.oracle.use_returning_into runtime parameter to 1 to configure the Applier to use the RETURNING INTO clause to insert change data into LOB and LONG columns. Oracle piecewise operations are supported for SQL Apply mode only. The Applier cannot load change data to Oracle LOB columns in Merge Apply mode. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
NUMBER( p ,s ) |
| - |
NVARCHAR( n ) | NVARCHAR( n' )
| - |
NVARCHAR2( n ) | NVARCHAR2( n' )
| - |
RAW( n ) |
| Oracle piecewise operations are supported for SQL Apply mode only. |
TIMESTAMP(0) | TIMESTAMP(0) | - |
TIMESTAMP(0) WITH LOCAL TIME ZONE | TIMESTAMP(0) WITH LOCAL TIME ZONE | - |
TIMESTAMP(0) WITH TIME ZONE | TIMESTAMP(0) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(1) | TIMESTAMP(1) | - |
TIMESTAMP(1) WITH LOCAL TIME ZONE | TIMESTAMP(1) WITH LOCAL TIME ZONE | - |
TIMESTAMP(1) WITH TIME ZONE | TIMESTAMP(1) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(2) | TIMESTAMP(2) | - |
TIMESTAMP(2) WITH LOCAL TIME ZONE | TIMESTAMP(2) WITH LOCAL TIME ZONE | - |
TIMESTAMP(2) WITH TIME ZONE | TIMESTAMP(2) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(3) | TIMESTAMP(3) | - |
TIMESTAMP(3) WITH LOCAL TIME ZONE | TIMESTAMP(3) WITH LOCAL TIME ZONE | - |
TIMESTAMP(3) WITH TIME ZONE | TIMESTAMP(3) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(4) | TIMESTAMP(4) | - |
TIMESTAMP(4) WITH LOCAL TIME ZONE | TIMESTAMP(4) WITH LOCAL TIME ZONE | - |
TIMESTAMP(4) WITH TIME ZONE | TIMESTAMP(4) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(5) | TIMESTAMP(5) | - |
TIMESTAMP(5) WITH LOCAL TIME ZONE | TIMESTAMP(5) WITH LOCAL TIME ZONE | - |
TIMESTAMP(5) WITH TIME ZONE | TIMESTAMP(5) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(6) | TIMESTAMP(6) | - |
TIMESTAMP(6) WITH LOCAL TIME ZONE | TIMESTAMP(6) WITH LOCAL TIME ZONE | - |
TIMESTAMP(6) WITH TIME ZONE | TIMESTAMP(6) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(7) | TIMESTAMP(7) | - |
TIMESTAMP(7) WITH LOCAL TIME ZONE | TIMESTAMP(7) WITH LOCAL TIME ZONE | - |
TIMESTAMP(7) WITH TIME ZONE | TIMESTAMP(7) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(8) | TIMESTAMP(8) | - |
TIMESTAMP(8) WITH LOCAL TIME ZONE | TIMESTAMP(8) WITH LOCAL TIME ZONE | - |
TIMESTAMP(8) WITH TIME ZONE | TIMESTAMP(8) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
TIMESTAMP(9) | TIMESTAMP(9) | - |
TIMESTAMP(9) WITH LOCAL TIME ZONE | TIMESTAMP(9) WITH LOCAL TIME ZONE | - |
TIMESTAMP(9) WITH TIME ZONE | TIMESTAMP(9) WITH TIME ZONE | Oracle TIMESTAMP WITH TIME ZONE in the time zone region (TZR) format is not supported. |
VARCHAR( n ) | VARCHAR( n' )
| - |
VARCHAR2( n ) | VARCHAR2( n' )
| Oracle piecewise operations are supported for SQL Apply mode only. |