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

Home -> Community -> Mailing Lists -> Oracle-L -> Materialized View over 2 tables

Materialized View over 2 tables

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Mon, 29 Oct 2001 23:50:30 -0800
Message-ID: <F001.003B7F33.20011029234017@fatcity.com> 









Hi!




Can I have a materialized view to be refreshed "fast", when it is created over 2 base tables? Fast refreshes work fine as long as the materialized view is based on 1 base table. But if the view is based on more base tables, it only seems to work with a complete refresh.



Does anybody have any experience with that problem?




This is 8.1.7 on Sun Solaris.




Thanks,


Helmut




Received on Tue Oct 30 2001 - 01:50:30 CST












Original text of this message













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