Re: oracle8 mat. view support

> > 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!
========================================