Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question on materialized view
"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