Oracle target data types
The Oracle database for Qlik Replicate supports most Oracle data types. The following table shows the Oracle target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
Qlik Replicate Data Types | Oracle Data Types |
---|---|
BOOLEAN |
NUMBER (1) |
BYTES |
RAW (length) |
DATE |
DATETIME |
TIME |
TIMESTAMP (0) |
DATETIME |
If scale <= 9, then TIMESTAMP (scale) Otherwise, VARCHAR2 (37) |
INT1 |
NUMBER (3) |
INT2 |
NUMBER (5) |
INT4 |
NUMBER (10) |
INT8 |
NUMBER (19) |
NUMERIC |
NUMBER (p,s) |
REAL4 |
BINARY_FLOAT |
REAL8 |
BINARY_DOUBLE |
STRING |
With date indication: DATE With time indication: TIMESTAMP With timestamp indication: TIMESTAMP With timestamp_with_timezone indication: TIMESTAMP WITH TIMEZONE With timestamp_with_local_timezone indication: TIMESTAMP WITH LOCAL TIMEZONE With interval_year_to_month indication: INTERVAL YEAR TO MONTH With interval_day_to_second indication: INTERVAL DAY TO SECOND If Length > 4000: CLOB In all other cases: VARCHAR2 (Length) |
UINT1 |
NUMBER (3) |
UINT2 |
NUMBER (5) |
UINT4 |
NUMBER (10) |
UINT8 |
NUMBER (19) |
WSTRING |
NVARCHAR2 (length) Note that when length is greater than 2000, the column data type will be NCLOB. |
BLOB |
BLOB Information noteTo use this data type in a replication task, you must enable the use of BLOBs for a specific task.
|
CLOB |
CLOB Information noteTo use this data type in a replication task, you must enable the use of CLOBs for a specific task.
|
NCLOB |
NCLOB Information noteTo use this data type in a replication task, you must enable the use of NCLOBs for a specific task.
|
The XMLTYPE target data type is only relevant in Oracle-to-Oracle replication tasks. See the note below. |
XMLTYPE |
When the source database is Oracle, the source data types will be replicated "as is" to the Oracle target. For example, an XMLTYPE data type on the source will be created as an XMLTYPE data type on the target.