---
title: "Data type mapping from Oracle to YugabyteDB"
url: "https://docs.yugabyte.com/stable/yugabyte-voyager/reference/datatype-mapping-oracle/"
---

# Data type mapping from Oracle to YugabyteDB

Refer to the data type mapping table when migrating data from Oracle to YugabyteDB using YugabyteDB Voyager.

- [MySQL to YugabytyeDB](/stable/yugabyte-voyager/reference/datatype-mapping-mysql/)
- [Oracle to YugabyteDB](/stable/yugabyte-voyager/reference/datatype-mapping-oracle/)

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                    |                                                                                                                                                                                        |
| VARCHAR2                       | VARCHAR                 |                                                                                                                                                                                        |
| NVARCHAR2                      | VARCHAR                 |                                                                                                                                                                                        |
| 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](https://github.com/yugabyte/yb-voyager/issues/779 "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.                                                                                                                                |
| NCLOB                          | TEXT                    | Data migration is allowed to a limit of 235MB per file.                                                                                                                                |
| 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](/stable/yugabyte-voyager/migrate/migrate-steps/#accelerate-data-export-for-mysql-and-oracle "BETA_FAST_DATA_EXPORT").                               |
| VARRAY                         | Composite type          | Unsupported when used with [BETA\_FAST\_DATA\_EXPORT](/stable/yugabyte-voyager/migrate/migrate-steps/#accelerate-data-export-for-mysql-and-oracle "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

- [Data modeling](/stable/develop/data-modeling/ "Data modeling")