1. Cache Guide
  2. Compatibility Between TimesTen and Oracle Databases
  3. Summary of Compatibility Issues

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.