Oracle source data types

The Oracle database for Qlik Replicate supports most Oracle data types. The following table shows the Oracle source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types.

For information on how to view the data type that is mapped in the target, see the section for the target database you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

Data types
Oracle Data Types	Qlik Replicate Data Types
BINARY_FLOAT	REAL4
BINARY_DOUBLE	REAL8
BINARY	BYTES
FLOAT (P)	REAL8
NUMBER (P,S) NUMBER according to the "Expose number as" property in the Qlik Replicate Oracle source database settings.	When scale is < 0: REAL8 When scale is 0 and: Precision = 0: REAL8 Precision < or = 2: INT1 Precision >2 and <or = 4: INT2 Precision >4 and <or = 9: INT4 Precision > 9: NUMERIC If precision > or = scale: NUMERIC In all other cases: REAL8
DATE	DATETIME
INTERVAL_YEAR TO MONTH	STRING (with interval year_to_month indication)
INTERVAL_DAY TO SECOND	STRING (with interval day_to_second indication)
TIMESTAMP	DATETIME
TIMESTAMP WITH TIME ZONE	STRING (with timestamp_with_timezone indication)
TIMESTAMP WITH LOCAL TIME ZONE	STRING (with timestamp_with_local_timezone indication)
CHAR	STRING
VARCHAR2	Length <= 4000 bytes: STRING Length > 4000 bytes: CLOB
NCHAR	Length <= 4000 bytes: WSTRING Length > 4000 bytes: NCLOB
NVARCHAR2	Length <= 4000 bytes: WSTRING Length > 4000 bytes: NCLOB
RAW	Length <= 2000 bytes: BYTES Length > 2000 bytes: BLOB
REAL	REAL8
BLOB To use this data type with Qlik Replicate, you must enable the use of BLOBs 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
CLOB To use this data type with Qlik Replicate, you must enable the use of CLOBs 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
NCLOB To use this data type with Qlik Replicate, you must enable the use of NCLOBs 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.	NCLOB
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
XMLTYPE Information note When replicating XML columns, performance can be improved by not using the Oracle 12 client. Support for the XMLTYPE data type requires the full Oracle Client (as opposed to the Oracle Instant Client). When the target column is a CLOB, both full LOB mode and limited LOB mode are supported (depending on the target). For more information, see LOB support in Task Settings/Metadata.	CLOB

Unsupported data types

The following data types are not supported:

BFILE
ROWID
REF
UROWID
ANYDATA
SDO_GEOMETRY
User-defined data types

Virtual columns are not supported.
As the ROWID data type is not supported, materialized views based on a ROWID column are also not supported.

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!

Leave your feedback here