Re: MV creation error

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: Vladimir.Begun@xxxxxxxxxx
  • Date: Thu, 10 Feb 2005 14:02:06 -0500

 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. :)
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 ---

Other related posts: