Mappings Between Oracle Database and TimesTen Data Types
When you choose data types for columns in the TimesTen cache tables, consider the data types of the columns in the Oracle Database tables and choose an equivalent or compatible data type for the columns in the cache tables.
Note:
TimeTen cache, including passthrough, does not support the Oracle Database ROWID
data type. However, you can cast a ROWID
data type to a CHAR(18)
when provided on the SELECT
list in a SQL query.
The following example demonstrates the error that is returned when you do not cast the ROWID
data type. Then, the example shows the correct casting of a ROWID
data type to CHAR(18)
:
Command> SET PASSTHROUGH 3; Passthrough command has set autocommit off. Command> SELECT ROWID FROM dual; 5115: Unsupported type mapping for column ROWID The command failed. Command> SELECT CAST (ROWID AS CHAR(18)) FROM DUAL; < AAAAB0AABAAAAEoAAA > 1 row found.
Primary and foreign key columns are distinguished from non-key columns. The data type mappings allowed for key columns in a cache table are shown in Table C-2.
Table C-2 Data Type Mappings Allowed for Key Columns
Oracle Database Data Type | TimesTen Data Type |
---|---|
|
Note: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table C-3 shows the data type mappings allowed for non-key columns in a cache table.
Table C-3 Data Type Mappings Allowed for Non-Key Columns
Oracle Database Data Type | TimesTen Data Type |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where |
|
Where |
|
|
|
|
Note: Includes |
Note: |
|
|
|
|
|
|
|
|
|
Where 1 <= |
|
Where 1 <= |
|
Where 1 <= |