When you import metadata from an Oracle database, the Administration Tool uses the mapping in the table to determine each imported column's corresponding Oracle BI Server data type.
The data types mapping to the Oracle BI EE data types differs depending on the kind of database that you are using.
For more information about Oracle Database data types, see "Chapter 26 Oracle Data Types" in Oracle Database Concepts.
Oracle Database Data Type | Oracle BI EE Data Type |
---|---|
CHAR |
CHAR |
NCHAR |
CHAR |
VARCHAR2 |
VARCHAR |
NVARCHAR2 |
VARCHAR |
NUMBER |
NUMERIC if ENABLE_NUMERIC_DATA_TYPE = YES; otherwise, DOUBLE |
NUMBER (precision, scale) |
INT if scale = 0 and 1 <= precision <= 9; otherwise, same as NUMBER |
BINARY_FLOAT |
FLOAT |
BINARY_DOUBLE |
DOUBLE |
DATE |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP WITH TIME ZONE |
TIMESTAMP |
TIMESTAMP WITH LOCAL TIME ZONE |
TIMESTAMP |
BLOB |
LONGVARBINARY |
CLOB |
LONGVARCHAR |
NCLOB |
LONGVARCHAR |
BFILE |
Not supported |
LONG |
LONGVARCHAR |
LONG RAW |
Not supported |
ROWID |
CHAR |
XML Type |
LONGVARBINARY |
UriType |
Not supported |