Newbie question on materialized view

From: inferno2000 <inferno2000_at_my-deja.com>
Date: 26 Nov 2002 02:34:54 -0800
Message-ID: <a9390719.0211260234.57876e00@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? Received on Tue Nov 26 2002 - 04:34:54 CST