Summary of Compatibility Issues
There are a few compatibility issues between the TimesTen and Oracle databases.
Consider the following differences between TimesTen and Oracle databases:
-
TimesTen and Oracle database metadata are stored differently. See API Compatibility.
-
TimesTen and Oracle databases have different transaction isolation models. See Transaction Semantics.
-
TimesTen and Oracle databases have different connection and statement properties. For example, TimesTen does not support catalog names, scrollable cursors or updateable cursors.
-
Sequences are not cached and synchronized between the TimesTen database and the corresponding Oracle database. See SQL Expressions.
-
Side effects of Oracle Database triggers and stored procedures are not reflected in the TimesTen database until after an automatic or manual refresh operation.