Jusung Yang wrote:
> 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.
>
>
> - Jusung Yang
>
>
> 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
>
If it isn't in the documentation examples, it will not work.
If it *is* in the examples, it _should_ work, unless it's a bug.
on commit refreshes do not work on 8i - it's a bug...
--
Regards, Frank van Bortel
Received on Sat Mar 01 2003 - 07:51:27 CST
