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 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. |
|
CLOB |
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. |
|
NCLOB |
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. |
|
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.