ORA-12054 when creating materialized view

From: Ed Wong <ewong_at_mail.com>
Date: 6 Feb 2003 19:12:06 -0800
Message-ID: <a5ae1554.0302061912.b54827d@posting.google.com>

When creating a materialized view, I received "ORA-12054 : cannot set the ON COMMIT refresh attribute for the materialized view" error message.

create materialized view target_mview
tablespace target_data
storage (pctincrease 0)
build immediate
refresh fast on commit
enable query rewrite
as select * from target
where targetid = 100 and targetname = 'XYZ';

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

"target" is a physical table and the query is pretty simple so I have no idea why I get this error. I've granted "global query rewrite".

I am using 8.1.7 EE on Sun Solaris. Please help. Thanks.

ewong Received on Thu Feb 06 2003 - 21:12:06 CST