| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Materialized View over 2 tables
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>That’s not
a problem. That is well-documented feature and you can check it with standard
documents.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Fast Refreshes
are meant only for simple MVs/Snapshots and not for complex ones. You are
supposed
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>to do a
complete refresh for complex ones.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>HTH,
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Rajesh
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Daiminger,
Helmut
Sent: Tuesday, October 30, 2001
11:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: Materialized View over 2
tables
<span
style='font-size:12.0pt'>
<span
style='font-size:10.0pt;font-family:Arial;color:black'>Hi!<font color=black> <span style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;font-family:Arial;color:black'>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.<span
style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;font-family:Arial;color:black'>Does anybody have any
experience with that problem?<span
style='color:black'> <span style='color:black;
mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;font-family:Arial;color:black'>This is 8.1.7 on Sun
Solaris. <font
color=black>
<span
style='font-size:10.0pt;font-family:Arial;color:black'>Thanks,<font
color=black>
<span style='font-size:10.0pt;
font-family:Arial;color:black'>Helmut<span
style='color:black'> <span style='color:black;
mso-color-alt:windowtext'>
Received on Tue Oct 30 2001 - 02:52:16 CST
 |
 |