Re: Materialized view

From: <jgaquino_at_my-deja.com>
Date: Sat, 11 Nov 2000 00:07:12 GMT
Message-ID: <8ui2jd$tlu$1@nnrp1.deja.com>

I've found that materialized views require that the query have a join or an aggregate.

Jon

Subject: Materialized view - ON COMMIT
Date: 07/10/2000
Author: Oleg Fedorenkov <ofed_at_com2com.ru>

<< previous · next in search >>

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 18:07:12 CST

Re: Materialized view - ON COMMIT