Re: Cannot create MV with refresh on commit

"bob123" <nomail_at_nowhere.com> a écrit dans le message de news: 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
|

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view  *Cause: The materialized view did not satisfy conditions for refresh at

          commit time.
 *Action: Specify only valid options.

Regards
Michel Received on Thu Sep 30 2010 - 15:43:11 CDT