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.