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.