Re: Newbie question on materialized view

"inferno2000" <inferno2000_at_my-deja.com> wrote in message news:a9390719.0211271844.afbf4bb_at_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
> ======

Hi again,

Did you try a count(*) as I initially suggested ?

Give it a go ...

Cheers

Richard Received on Fri Nov 29 2002 - 08:28:01 CST