Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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! ========================================Received on Thu Apr 19 2001 - 07:45:23 CDT
![]() |
![]() |