Fast refresh materialized views - restrictions

From: jorgenbaz <member25683_at_dbforums.com>
Date: Thu, 27 Feb 2003 12:13:49 +0000
Message-ID: <2581994.1046348029@dbforums.com>

Hi all!

Im trying to find out what the restrictions are on fast refresh mv's in oracle9i2 (which I currently do not have installed). The documentation seemed to be clear on the topic (when I was reading Advanced Replication Guide), but then i read Data Wareh. Guide, which states different rules.

An example:

---

ARG page 3-10 says: "a complex mv cannot be fast refreshed (...) a mv is considered complex when the defining query contains joins other than those in a subquery"

DWG page 8-16 says: "fast refresh for a mv containing only joins is possible..."

Why are the restrictions different in replication and data warehouse? is it possible to create a mv in a "general" environment, thus ommiting both the replication-restrictions and the dwh restrictions?

links:
Advanced Replication Guide and Data Warehouse Guide can be downloaded on this page:
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage

--

Posted via http://dbforums.com Received on Thu Feb 27 2003 - 06:13:49 CST