Re: licensing query

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 7 Dec 2001 14:57:46 -0000
Message-ID: <3c10d8da$0$8507$ed9e5944@reading.news.pipex.net>

My problem was reading (with the first column being for standard edition)

      Data Warehousing and VLDB
     Materialized views
     N
     Y
     Y
     Includes summary management functionality, join indexes, and summary

advisor. Powerful functionality that automatically redirects queries to stored summary tables, improving query performance dramatically.

and from replication

      Distributed
     Basic replication
     Y
     Y
     Y
     Oracle8i server fully supports bi-directional replication with

automated conflict detection and resolution. Supported configurations include a single updatable master site with multiple updatable or read-only snapshot sites.

which of course doesn't mention materialized views. I still think that this is misleading as its not the materialized view funtionality that is unavailable but query rewrite which is unavailable. Anyway I'm happy I'm legal now.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3c10ce5c.9448657_at_news...


> Niall Litchfield doodled thusly:

>

> >Advanced replication                                             FALSE

>

> This is the bit I was looking for.  According to ORACLE, Advanced

> Replication is master-to-master.  Which doesn't include snapshots

> (materialised views).

> So, it may well be working.

>

> >what are you doing up at this time?

>

> Huh?  Friday 1am is late?   ;-)

>

> >

> >Upon further thinking I'm assuming that because a materialized view is

> >effectively `a snapshot and standard edition is supposed to deal with the

> >multiple small shops scenario perhaps the snapshot functionality only is

> >available.

> >

>

> Exactly.

>

>

> Cheers

> Nuno Souto

> nsouto_at_optushome.com.au.nospam

Received on Fri Dec 07 2001 - 08:57:46 CST