Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question on materialized view

Re: Newbie question on materialized view

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 27 Nov 2002 00:10:53 +1000
Message-ID: <1bKE9.84228$g9.237932@newsfeeds.bigpond.com>


"inferno2000" <inferno2000_at_my-deja.com> wrote in message news:a9390719.0211260234.57876e00_at_posting.google.com...
> I am stuck, I could not create a materialized view with on-commit fast
> refresh option. What is possibly wrong with the syntax below?
>
> create materialized view log on comh_contr
> with rowid (client_cd, brok)
> including new values
> /
>
> create materialized view mv_comh_contr_brok
> build immediate
> refresh fast on commit
> enable query rewrite
> as
> select
> client_cd,
> sum(brok) brok,
> count(1) num
> from comh_contr
> group by client_cd
> /
>
> The second statement keeps causing "ORA-12054: cannot set the ON
> COMMIT refresh attribute for the materialized view" error.
>
> Any idea?

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:

Good Luck

Richard Received on Tue Nov 26 2002 - 08:10:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US