Language Elements and Features Not Supported by TimesTen
These language elements are features are not supported in TimesTen.
-
Features: autonomous transactions, database links (dblinks), result cache, savepoints, triggers, user-defined objects or collections
While TimesTen does not support triggers, you can achieve similar functionality using XLA. See XLA and TimesTen Event Management in Oracle TimesTen In-Memory Database C Developer's Guide.
-
Statements:
CREATE LIBRARY
,CREATE TYPE
,LOCK TABLE
,SAVEPOINT
,SET TRANSACTION
-
Pragmas:
AUTONOMOUS_TRANSACTIONS
,RESTRICT_REFERENCES
,SERIALLY_REUSABLE
-
SYSTIMESTAMP
: TimesTen cannot support this because the return type,TIMESTAMP WITH TIME ZONE
, is not supported. As an alternative, you can useSELECT tt_sysdate FROM dual
using dynamic SQL:declare ts timestamp; begin execute immediate 'select tt_sysdate from dual' into ts; -- ts has millisecond resolution end;