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 Oracle 12c data types mapping to the Oracle BI EE data types could differs depending on the your specific database.
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 |