Materialized view - ON COMMIT

From: Oleg Fedorenkov <ofed_at_com2com.ru>
Date: 2000/07/10
Message-ID: <8kftqf$is8$1@storm.comstar.ru>#1/1

Hi, All!
I am having a headache now how to force materialized view to refresh on commit(Oracle 8.1.5 EE NT4.0)
Whatever I was doing, I was getting ORA-12051 on simple select view, even if I hadn't any aggregates( really we have need of view of aggregated sums like "select raschet.date_month,account_num,sum(raschet.summa) from raschet group by date_month,account_num"), on single table!. I could write trigger to do the same work, but writing materialized view appeared to me simpler,heh. Refreshing on scheduling basis seems to my manager not acceptable.
Bad syntax? ini parameter? Bad installation? What's wrong? I would be appreciated to receive any suggestions

Oleg Fedorenkov,DBA

---

SQL> create materialized view log on raschet with rowid;

Materialized view log created.

SQL> create materialized view account_status   2 refresh fast on commit as
  3 select raschet_id from raschet
  4 /
select raschet_id from raschet

                       *

ERROR at line 3:
ORA-12051: ON COMMIT attribute is incompatible with other options Received on Mon Jul 10 2000 - 00:00:00 CDT