Re: Oracle and (Cached?) Views

Sybrand Bakker wrote:
>
> On Tue, 09 Jul 2002 01:39:28 GMT, Bob Kosman <lucent_at_dtransform.com>
> wrote:
>
> >Running Oracle 8, we have a view which takes a reasonable
> >amount of time. An associate mentioned to me that he thought
> >it was possible to make Oracle cache a view such that
> >subsequent re-running of it would be more efficient.
> >
> >Has anyone heard of this?
> >
> >TIA.
> >
> >Kos.
>
> Oracle 8i has materialized views.
> Oracle 8 has been desupported
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Well, you can still get support for 8.0.6.x

... then again, 8.0.? ... Ugh!

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."