1. Cache Guide
  2. Compatibility Between TimesTen and Oracle Databases
  3. SQL Compatibility
  4. Schema Objects
  5. Caching Oracle Database Partitioned Tables

Caching Oracle Database Partitioned Tables

TimesTen can cache Oracle Database partitioned tables at the table level, but individual partitions cannot be cached.

The following describes how operations on partitioned tables affect cache groups:

  • DDL operations on a table that has partitions do not affect the cache group unless there is data loss. For example, if a partition with data is truncated, an AUTOREFRESH operation does not delete the data from the corresponding cached table.

  • WHERE clauses in any cache group operations cannot reference individual partitions or sub-partitions. Any attempt to define a single partition of a table returns an error.