Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: licensing query
PARAMETER VALUE ---------------------------------------------------------------- ----------- --- Partitioning FALSE Objects TRUE Parallel Server FALSE Advanced replication FALSE Bit-mapped indexes FALSE Connection multiplexing TRUE Connection pooling TRUE Database queuing FALSE Incremental backup and recovery FALSE Instead-of triggers TRUE Parallel backup and recovery FALSE Parallel execution FALSE Parallel load TRUE Point-in-time tablespace recovery FALSE Fine-grained access control FALSE N-Tier authentication/authorization TRUE Function-based indexes FALSE Plan Stability FALSE Online Index Build FALSE Coalesce Index FALSE Managed Standby FALSE Materialized view rewrite FALSE Materialized view warehouse refresh FALSE Database resource manager FALSE Spatial FALSE Visual Information Retrieval FALSE Export transportable tablespaces FALSE Transparent Application Failover FALSE Fast-Start Fault Recovery FALSE Sample Scan FALSE Duplexed backups FALSE Java FALSE OLAP Window Functions FALSE
33 rows selected.
what are you doing up at this time?
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.
-- 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:3c10adfb.1159024_at_news...Received on Fri Dec 07 2001 - 08:12:22 CST
> 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