Re: Problem with Materialized Views and Fast Refresh

I have the same sort of problem on 8.1.5 My current work around was to switch to rowid In your case:

    with rowid (y)
looks as if it should work

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Bruce Cota wrote in message <3950C1B7.2F82E11E_at_vivi.com>...


>This is so simple , I have to be doing something dumb, but I can't see

>it and I've been waiting

>over a week for Oracle Support to respond.

>

>In the following example, I don't understand why I can't use the

>materialized view log

>for a fast refresh.   Thanks in advance for any illumination.

>

>-Bruce

>

>10:23:22 CNDEV2> create table t (pk number primary key, x number, y

>number);

>

>Table created.

>

>10:23:24 CNDEV2> create materialized view log on t with primary key

>including new values;

>

>Materialized view log created.

>

>10:23:28 CNDEV2> create materialized view t_view refresh fast as

> select count(*), y from t group by y;

>

>10:23:33   2   select count(*), y from t group by y

>                         *

>ERROR at line 2:

>ORA-12032: cannot use rowid column from snapshot log on "T"

>

>