问这个问题的初衷是希望能够在Oracle中通过视图关联多张表,然后将结果集缓存到TimesTen.
不过答案是不支持,在Cache User Guide第245页,明确指出:
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.
视图是不支持的,物化视图支持,但有太多限制条件。所以视图之类的就别考虑的,原因应该是视图不能保证主键或唯一索引
新闻热点
疑难解答