licensing query

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

My understanding from the getting to know oracle 8i reference material is that materialized views are an enterprise edition fetaure. This is a shame as I'd like to use them.

However I get the following output from sqlplus suggesting that in fact materialised views are available?

SQL> create materialized view nl_people
  2 as select * from v_people@<remotedb>   3 ;

Materialized view created.

SQL> select * from v$version;

BANNER

---

Oracle8i Release 8.1.7.2.1 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.2.0 - NLSRTL Version 3.4.1.0.0 - Production

So I'm all confused. Do I use the feature (and find it disappears in a future release) or is there an explanation I'm missing.

--

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

---

Received on Fri Dec 07 2001 - 05:34:30 CST