Skip to main content

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.

Information note
  • 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.
Non-identical data types in homogeneous replication
Oracle data types Qlik Talend Data Integration 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 Talend 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 Talend Data Integration, you must enable the use of LOBs for a specific task.

BLOB

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!