Homogeneous replication
With the exception of the data types listed in the table below, when replicating from an Oracle source to an Oracle target, all of the source and target data types will be identical. Note that homogeneous replication is only relevant with Replication data projects.
- As of Oracle 9.0, the LONG and LONG RAW data types are no longer supported by Oracle.
- Primary/Unique Index names are preserved during homogeneous replication.
| Oracle data types | Data Movement gateway data types |
|---|---|
|
VARCHAR2 |
Length > 4000 bytes: CLOB |
|
NVARCHAR2 |
Length > 4000 bytes: NCLOB |
|
RAW |
Length > 2000 bytes: BLOB |
|
LONG The LONG data type is not supported in Batch optimized Apply Mode. To use this data type with Qlik Cloud Data Integration, you must enable the use of LOBs for a specific task.
|
CLOB |
|
LONG RAW The LONG RAW data type is not supported in Batch optimized Apply Mode. To use this data type with Qlik Cloud Data Integration, you must enable the use of LOBs for a specific task.
|
BLOB |