Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> fast refresh of MV based on a view

fast refresh of MV based on a view

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Fri, 12 May 2006 16:38:35 +0200 (CEST)
Message-ID: <48876.213.162.65.17.1147444715.bloek@pwebmail.utanet.at>


Hi,

I try to define a MV based on a (very simple) view. There are some problems with fast refresh (complete refresh works fine) – see below. Can anybody explain me why is fast refresh not possible? There are no sysdates, rownum1, joins, unions etc. where the fast refresh doesn't work on the documented way!
Interestingly if the MV accesses the source view over a dblink the error message is slightly different:
ORA-12014: table 'VV' does not contain a primary key constraint

Thanks,

Jaromir

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit

SQL> create table tt (i number primary key);

Table created.

SQL> create view vv as select * from tt;

View created.

SQL> CREATE MATERIALIZED VIEW LOG ON tt WITH primary key, rowid;

Materialized view log created.

SQL> create materialized view mm
  2 build immediate
  3 refresh fast on demand
  4 as
  5 select * from vv;
select * from vv

               *
ERROR at line 5:
ORA-12015: cannot create a fast refresh materialized view from a complex query

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 12 2006 - 09:38:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US