Compatibility Issues Between the TimesTen and Oracle Databases

There are some compatibility issues between the TimesTen and Oracle databases.

For example:

  • TimesTen and Oracle database metadata are stored differently.

  • TimesTen and Oracle databases have different transaction isolation models.

  • TimesTen and Oracle databases have different connection and statement properties.

  • Sequences are not cached and synchronized between the TimesTen database and the corresponding Oracle database.

  • Side effects of Oracle database triggers and stored procedures are not reflected in the TimesTen database until after an automatic or manual refresh operation.

See Compatibility Between TimesTen and Oracle Databases in Oracle TimesTen In-Memory Database Cache Guide.