Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: licensing query

Re: licensing query

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Fri, 07 Dec 2001 11:54:56 GMT
Message-ID: <3c10adfb.1159024@news>


Niall Litchfield doodled thusly:

>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
>

What does v$option contain?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Dec 07 2001 - 05:54:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US