Data type mapping from Oracle to YugabyteDB

The following table includes a list of supported data type mappings for migrating data from Oracle to YugabyteDB using YugabyteDB Voyager:

Oracle data type Maps to YugabyteDB as Comments
CHAR CHAR
NCHAR CHAR Unsupported in Live migration, or Live migration with fall-forward
VARCHAR2 VARCHAR
NVARCHAR2 VARCHAR Unsupported in Live migration, or Live migration with fall-forward
RAW BYTEA
LONG RAW BYTEA
DATE TIMESTAMP
TIMESTAMP WITH TIMEZONE TIMESTAMP WITH TIMEZONE
TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP WITH TIMEZONE
TIMESTAMP TIMESTAMP
INTERVAL YEAR TO MONTH INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND INTERVAL DAY TO SECOND
LONG TEXT
FLOAT DOUBLE PRECISION
BINARY_FLOAT DOUBLE PRECISION
BINARY_DOUBLE DOUBLE PRECISION
NUMBER NUMERIC
NUMBER(3) SMALLINT
NUMBER(3,2) NUMERIC(3,2)
NUMBER(2,7) NUMERIC
NUMBER(6,-2) NUMERIC(6,-2) Results in an error because negative scale is currently not supported. Refer to the GitHub issue for more details.
BLOB BYTEA Data is ignored during export. Only the schema migration is allowed. Please use another mechanism to load the values.
CLOB TEXT Data migration is allowed to a limit of 235MB per file. Unsupported in Live migration, Live migration with fall-forward
NCLOB TEXT Data migration is allowed to a limit of 235MB per file. Unsupported in Live migration, Live migration with fall-forward
BFILE BYTEA Not supported.
ROWID OID Currently, import schema is supported. Data import results in an error.
UROWID [(size)] OID Currently, import schema is supported. Data import results in an error.
SYS.AnyData ANYDATA Not supported.
SYS.AnyType ANYTYPE Not supported.
SYS.AnyDataSet ANYDATASET Not supported.
XMLType XML Currently, import schema is supported. Data import results in an error.
URIType URITYPE Not supported.
Objects Not supported.
REF Not supported.
Nested tables Composite type Unsupported when used with BETA_FAST_DATA_EXPORT, and in Live migration or Live migration with fall-forward
VARRAY Composite type Unsupported when used with BETA_FAST_DATA_EXPORT.

ANSI supported data types

The following table list the ANSI supported data types that can be mapped to YugabyteDB:

ANSI supported data type Maps to YugabyteDB as
CHARACTER(n) CHAR(n)
CHAR(n) CHAR(n)
CHARACTER VARYING(n) VARCHAR(n)
CHAR VARYING(n) VARCHAR(n)
NATIONAL CHARACTER(n) CHAR(n)
NATIONAL CHAR(n) CHAR(n)
NCHAR(n) CHAR(n)
NATIONAL CHARACTER VARYING(n) VARCHAR(n)
NATIONAL CHAR VARYING(n) VARCHAR(n)
NCHAR VARYING(n) VARCHAR(n)
NUMERIC[(p,s)] REAL
DECIMAL[(p,s)] REAL
INTEGER NUMERIC(38)
INT NUMERIC(38)
SMALLINT NUMERIC(38)
FLOAT DOUBLE PRECISION
DOUBLE PRECISION DOUBLE PRECISION
REAL DOUBLE PRECISION

Learn more