Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: licensing query
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