Re: MV creation error

 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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: