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.
- 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.
- In homogeneous replication, the source data first passes through the Qlik Replicate data type and is therefore subject to any limitations of that type.
- For information on Replicate data types and their limitations (where relevant), see Replicate data types.
- For information on which Replicate data types the source data passes through when replicating from Oracle, see the Oracle to Qlik Replicate data types mapping table described earlier.
| Oracle Data Types | Qlik Replicate 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 Replicate, you must enable the use of LOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
CLOB |
|
LONG RAW The LONG RAW data type is not supported in Batch optimized apply mode. To use this data type with Qlik Replicate, you must enable the use of LOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
BLOB |