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 --- Links --- 1 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#574693 2 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#40960 -- //www.freelists.org/webpage/oracle-l