Re: Newbie question on materialized view

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 29 Nov 2002 14:00:46 -0000
Message-ID: <as7rvi$ii2$1$8302bc10@news.demon.co.uk>

But it is a single table aggregate view.

The simple example works in 9.2,
but does not work in 8.1.7.0 - however,
ON DEMAND works in 8.1.7.0 - which
suggests that in theory the ON COMMIT
ought to be capable of working.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____Denver_______December 2/4
____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Patrick Meyer wrote in message
<347513424b16cec2e426045ab4572460.61632_at_mygate.mailgate.org>...


>A quick glance at the documentation revealed the following

restrictions


>for the ON COMMIT clause:

>

>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.

>

>>

>> 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

>> ======

>

Received on Fri Nov 29 2002 - 08:00:46 CST