Materialized View - newbie question

From: Kurt Grassl <post_at_kurtgrassl.de>
Date: 18 Apr 2005 05:11:53 -0700
Message-ID: <70c158ad.0504180411.18505816@posting.google.com>

Hi,

I'm new to Oracle and I'm trying to reproduce some data-warehouse-functionality that we've already written in Visual FoxPro with Oracle's Materialized Views

I created a lot materialized views which worked cool until I tried to insert data into the fact table -> it's too slow.

In the documention I found fast refresh, but I can't get it to work. I get
'ORA-12033: cannot use filter columns from materialized view log on "CUBE"."AUFTPOS" when I try

create materialized view log on cube.auftpos

    WITH ROWID (datum_j, datum_m, ANR)
    INCLUDING NEW VALUES;      create materialized view cube.MV_Anr_Knr_Adl_Gs_Adm_M   organization heap
  refresh with rowid fast on commit
as
  select Datum_J, Datum_M, Anr, SUM(Menge) as Menge, count(*), count(Menge)

from cube.auftpos
group by datum_j, datum_m, anr

What's wrong with this commands?

Thanks
Kurt Received on Mon Apr 18 2005 - 07:11:53 CDT