Updated on 2025-09-09 GMT+08:00

Mapping Between Oracle and Doris 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 Doris.

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

Type

Oracle Data Type

Doris Data Type

Description

String

CHAR(M)

CHAR(M)

Fixed-length string, filled with spaces

NCHAR(M)

CHAR(M)

Fixed-length string, filled with spaces

VARCHAR2(M)

VARCHAR(M)

Variable-length string

NVARCHAR2(M)

VARCHAR(M)

Variable-length string

ROWID

TEXT

Variable-length string

UROWID

TEXT

Variable-length string

Value

NUMBER(M,D)

DECIMAL(M,D)/STRING

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.

DECIMAL(M,D)

DECIMAL(M,D)/TEXT

Equivalent to NUMBER

NUMERIC(M,D)

DECIMAL(M,D)/TEXT

Equivalent to NUMBER

FLOAT(M)

DOUBLE/TEXT

If the value of M is greater than 53, the precision of Oracle FLOAT exceeds that of Doris DOUBLE. The STRING type is used.

If the value of M is less than or equal to 53, the DOUBLE type is used.

BINARY_FLOAT

FLOAT

Single-precision floating point number (4 bytes)

BINARY_DOUBLE

DOUBLE

Double-precision floating point number (8 bytes)

Date and time

DATE

DATETIME

Date and time

TIMESTAMP(M)

DATETIME(M)/TEXT

Date and time

If the value of M is less than or equal to 6, the DATETIME type is used.

If the value of M is greater than 6, the TEXT type is used.

TIMESTAMP(M) WITH TIME ZONE

DATETIME(M)/TEXT

Date and time

If the value of M is less than or equal to 6, the DATETIME type is used.

If the value of M is greater than 6, the TEXT type is used.

TIMESTAMP(M) WITH LOCAL TIME ZONE

DATETIME(M)/TEXT

Date and time

If the value of M is less than or equal to 6, the DATETIME type is used.

If the value of M is greater than 6, the TEXT type is used.

Binary

BLOB

TEXT

Variable-length string

CLOB

TEXT

Variable-length string

NCLOB

TEXT

Variable-length string

RAW

TEXT

Variable-length string

LONG

TEXT

Variable-length string

LONG RAW

TEXT

Variable-length string