Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Real-Time Jobs)/ Field Type Mapping/ Mapping Between Oracle and DWS Field Types
Updated on 2026-08-13 GMT+08:00
View PDF
Share

Mapping Between Oracle and DWS Field Types

DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.

Field Type Mapping Rules

The following table lists the field types supported by a job that migrates data from Oracle to DWS.

Table 1 Field types supported by a job that migrates data from Oracle to DWS

Type

Oracle Data Type

DWS Data Type

Description

Numeric

NUMBER

NUMBER

Accurate number with precision

You can specify the Doris version by setting the targetVersion parameter in the advanced settings of the destination configuration.

If targetVersion is greater than or equal to 1.2.1, the maximum value of M is 38.

If targetVersion is less than 1.2.1, the maximum value of M is 27.

If the value of M at the source exceeds the maximum value, the TEXT type is used.

FLOAT

FLOAT8

Double-precision floating point number (8 bytes)

BINARY_FLOAT

FLOAT4

Single-precision floating point number (4 bytes)

DECIMAL(M,D)

NUMBER

Equivalent to NUMBER

BINARY_DOUBLE

FLOAT8

Double-precision floating point number (8 bytes)

Time

DATE

TIMESTAMP

Date and time

TIMESTAMP [(p)]

TIMESTAMP [(p)]

Date and time

TIMESTAMP [(p)] WITH TIME ZONE

TIMESTAMPTZ[(p)]

Date and time, with the time zone

TIMESTAMP [(p)] WITH LOCAL TIME ZONE

TIMESTAMPTZ[(p)]

Date and time, with the local time zone

String

CHAR(n)

CHAR(n)

Fixed-length string, filled with spaces

NCHAR(n)

NCHAR(n)

Fixed-length string, filled with spaces

NVARCHAR2(n)

NVARCHAR(n)

Variable-length string

VARCHAR(n)

VARCHAR(n)

Variable-length string

VARCHAR2(n)

VARCHAR(n)

Variable-length string

Other Oracle data types, such as CLOB and BLOB, are not supported by Migration Oracle.

Parent topic: Field Type Mapping