Default forward data type mappings for Oracle NET8 data sources

The following table lists the default forward data type mappings for Oracle NET8 data sources.

Table 1. Oracle NET8 default forward data type mappings
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
BLOB 0 0 0 0 - \0 BLOB 2147483647 0 Y
CHAR 1 254 0 0 - \0 CHAR 0 0 N
CHAR 255 2000 0 0 - \0 VARCHAR 0 0 N
CLOB 0 0 0 0 - \0 CLOB 2147483647 0 N
DATE 0 0 0 0 - \0 TIMESTAMP(6) 0 0 N
FLOAT 1 126 0 0 - \0 DOUBLE 0 0 N
LONG 0 0 0 0 - \0 CLOB 2147483647 0 N
LONG RAW 0 0 0 0 - \0 BLOB 2147483647 0 Y
NUMBER 10 18 0 0 - \0 BIGINT 0 0 N
NUMBER 1 38 -84 127 - \0 DOUBLE 0 0 N
NUMBER 1 31 0 31 - >= DECIMAL 0 0 N
NUMBER 1 4 0 0 - \0 SMALLINT 0 0 N
NUMBER 5 9 0 0 - \0 INTEGER 0 0 N
NUMBER - 10 0 0 - \0 DECIMAL 0 0 N
RAW 1 2000 0 0 - \0 VARCHAR 0 0 Y
ROWID 0 0 0 NULL - \0 CHAR 18 0 N
TIMESTAMP(p) 1 - - - - - \0 TIMESTAMP(6) 10 6 N
VARCHAR2 1 4000 0 0 - \0 VARCHAR 0 0 N
Note:
    • TIMESTAMP(p) represents a timestamp with a variable scale from 0-9. The scale of the Oracle timestamp is mapped to TIMESTAMP(6) by default. You can change this default type mapping and map the Oracle TIMESTAMP to a federated TIMESTAMP of the same scale by using a user-defined type mapping.
    • This type mapping is valid only for Oracle 9i (or later) client and server configurations.