1. Cache Guide
  2. Compatibility Between TimesTen and Oracle Databases
  3. SQL Compatibility
  4. Schema Objects

Schema Objects

TimesTen does not recognize some of the schema objects that are supported in Oracle Database.

TimesTen returns a syntax error when a statement manipulates or uses these objects. TimesTen passes the statement to Oracle Database. The unsupported objects are:

  • Clusters
  • Objects created by the CREATE DATABASE statement
  • Objects created by the CREATE JAVA statement
  • Database links
  • Database triggers
  • Dimensions
  • Extended features
  • External procedure libraries
  • Index-organized tables
  • Mining models
  • Partitions
  • Object tables, types and views
  • Operators

TimesTen supports views and materialized views, but it cannot cache an Oracle Database view. TimesTen can cache an Oracle Database materialized view in a user-managed cache group without the AUTOREFRESH cache group attribute and PROPAGATE cache table attribute. The cache group must be manually loaded and flushed.