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

Home -> Community -> Usenet -> c.d.o.tools -> Re: oracle8 mat. view support

Re: oracle8 mat. view support

From: Brian Peasland <peasland_at_usgs.gov>
Date: Thu, 19 Apr 2001 12:45:23 GMT
Message-ID: <3ADEDDE3.2B05C1F9@usgs.gov>

> > No. The closest you can get is a SNAPSHOT. While similar, there are
> > differences. Chief among those differences is that Materialized Views
> > support Query Rewrite while Snapshots do not.
>
> No. Absolutely no!
> Materialized views and snapshots are the same objects in Oracle.
> The query rewrite feature is introduced since Oracle 8.1, not available in Oracle8.0.

Materialized Views and snapshots are *not* technically the same objects. A Materialized View is a snapshot with Query Rewrite capabilities. If you are not using Query Rewrite, then there is no difference. Materialized Views also introduced Dimensions. In Oracle 8i, Snapshots are now implemented as Materialized Views.

> The only thing you have to do is to use the word "snapshot" instead of
> "materialized view" in Oracle8.

To do this is to not understand the differences between the two capabilities in Oracle 8 and Oracle 8i. There is a difference. This can lead to confusion, especially for a less seasoned DBA who is working on both platforms.

Cheers,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Thu Apr 19 2001 - 07:45:23 CDT

Original text of this message

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