Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fast refresh materialized views - restrictions
I don't think ORACLE has separate rules for different environment in
deciding whether a MV is fast refreshable. I would take what you read
from the DOC regarding rules on MV with a grain of salt. It is easier
to just create the MV and find out for yourself what is possible -
fast refresh, on commit, etc.. If you are using 9i,
DBMS_MVIEW.EXPLAIN_MVIEW can also help you determine what is or is not
possible with a particular MV.
jorgenbaz <member25683_at_dbforums.com> wrote in message news:<2581994.1046348029_at_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
Received on Thu Feb 27 2003 - 14:13:46 CST