Cannot create MV with refresh on commit
From: bob123 <nomail_at_nowhere.com>
Date: Thu, 30 Sep 2010 22:09:09 +0200
Message-ID: <4ca4ee6b$0$8109$426a34cc_at_news.free.fr>
HI,
Date: Thu, 30 Sep 2010 22:09:09 +0200
Message-ID: <4ca4ee6b$0$8109$426a34cc_at_news.free.fr>
HI,
Do you know how I can create MV with refresh on commit ?
(10.2.0.4)
Thanks in advance
1 CREATE MATERIALIZED VIEW MV_NAME_LIST
2 BUILD IMMEDIATE
3 REFRESH on commit
4 ENABLE QUERY REWRITE
5 AS
6 SELECT DISTINCT CODENAME, CODE, LABEL
7 FROM CTSDD.ITEM, CTSCODES.AGGREGATED_CODES
8* WHERE CODENAME = CODELIST
T18> /
FROM CTSDD.ITEM, CTSCODES.AGGREGATED_CODES
*
ERROR at line 7:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
view
Received on Thu Sep 30 2010 - 15:09:09 CDT