Vladimir Begun wrote: Mladen Gogala wrote: The fine manual tells you that
you cannot use fast refresh with group functions. This statement is too bold
to be true, you'd find opposite in the Data Warehouse guide. :)
http://download
-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#574693[1]
Restrictions on Fast Refresh on Materialized Views with Joins Only
Defining queries for materialized views with joins only and no aggregates
have the following restrictions on fast refresh:
- All restrictions from "General Restrictions on Fast Refresh"[2].
- They cannot have GROUP BY clauses or aggregates.
-- Mladen Gogala Oracle DBA Ext. 121
Received on Thu Feb 10 2005 - 14:05:39 CST
