Re: Newbie question on materialized view

A quick glance at the documentation revealed the following restrictions for the ON COMMIT clause:

"Specify ON COMMIT to indicate that a fast refresh is to occur whenever Oracle commits a transaction that operates on a master table of the materialized view.

Restriction: This clause is supported only for materialized join views and single-table materialized aggregate views."

It would seem that your single table would not quailfy for the ON COMMIT clause. Remove ON COMMIT from your definition and see if it works.

HTH,
Patrick

> I still have no luck yet. I am running Oracle 8i (8.1.7) with
> compatibility being set to 8.1.0.
>
> SQL> create materialized view mv_t_test
> 2 build immediate
> 3 refresh fast on commit
> 4 enable query rewrite
> 5 as
> 6 select
> 7 f1,
> 8 sum(f2),
> 9 count(f2)
> 10 from t_test
> 11 group by f1
> 12 /
> from t_test
> *
> ERROR at line 10:
> ORA-12054: cannot set the ON COMMIT refresh attribute for the
> materialized view
> ======

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG