問這個問題的初衷是希望能夠在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.
視圖是不支持的,物化視圖支持,但有太多限制條件。所以視圖之類的就別考慮的,原因應該是視圖不能保證主鍵或唯一索引
新聞熱點
疑難解答