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