Re: Newbie question on materialized view

From: inferno2000 <inferno2000_at_my-deja.com>
Date: 27 Nov 2002 18:44:43 -0800
Message-ID: <a9390719.0211271844.afbf4bb@posting.google.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<1bKE9.84228$g9.237932_at_newsfeeds.bigpond.com>...
> Hi Inferno2000,
>
> Please supply Oracle version as what is/isn't fast refreshable changes from
> release to release but a couple of ideas that pop into my little head (not
> tested) are:
>
> - include a count(brok)
> - use count(*) , I'm not sure how Oracle feels about count(1)
>

I still have no luck yet. I am running Oracle 8i (8.1.7) with compatibility being set to 8.1.0.

I tried a simpler example just now and still get the same error:

---

SQL> create table t_test (f1 number, f2 number);

Table created.

 real: 60
SQL> create materialized view log on t_test   2 with rowid (f1, f2)
  3 including new values
  4 /

Snapshot log created.

 real: 110
SQL> create materialized view mv_t_test
  2 build immediate
  3 refresh fast on commit
  4 enable query rewrite
  5 as
  6 select
  7 f1,
  8 sum(f2),
  9 count(f2)
 10 from t_test
 11 group by f1
 12 /
from t_test

     *
ERROR at line 10:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

---

Received on Wed Nov 27 2002 - 20:44:43 CST