Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: oracle8 mat. view support
"Brian Peasland" <peasland_at_usgs.gov> ????? news:3ADD90AA.CC366E4B_at_usgs.gov...
>
>
> > Does oracle8 support materialized views??
>
> 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.
> > I know oracle 8i does, but I'm not sure about oracle8. I don't see why not!
>
> Simply because the option had to get introduced at some point. Oracle 8i
> was the introduction of Materialized Views.
No. This "option" was not introduction in Oracle8i. Just because in Oracle8i, snapshots are called as materialized views.
> > If mat. views aren't supported by oracle8, is it possible to just define a
> > table containing the same aggregates (and then: what is the difference with
> > a summary table=mat view ??)
>
> It is possible to create your own summary tables in Oracle 8, but you'll
> have to code the update routines when the base tables are changed.
> Materialized views handle this for you.
No, of cause.
The only thing you have to do is to use the word "snapshot" instead of
"materialized view" in Oracle8.
Take a look at Oracle8i SQL Reference, Oracle8i Concepts, Oracle8i Replications ... and other manuals, they all tell you "materialized views" and "snapshot" are the same. Received on Thu Apr 19 2001 - 03:55:34 CDT