Supported data types
The following table shows the supported Oracle source data types and their default mapping to Replicate data types.
When replicating to an Oracle -based target, the source and target data types are the same, apart from the exceptions described in Homogeneous Replication.
For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.
For additional information about Replicate data types, see Replicate data types.
Oracle data types | 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.
|
BLOB |
CLOB To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task.
|
CLOB |
NCLOB To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task.
|
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.
|
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.
|
BLOB |
XMLTYPE Information note
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 see 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.