Oracle8 Getting to Know Oracle8 and the Oracle8 Enterprise Edition Release 8.0 A58228-01 |
Library | Product | Contents | Index

# 3
Differences between Oracle8 and the Oracle8 Enterprise Edition

The following topics are included in this chapter:

- Feature Factoring
- The V$OPTION Table
- Factoring-Related Error Message

## Feature Factoring

Feature factoring is how Oracle controls which features and options are included with each product configuration. Some features of the Oracle8 Enterprise Edition are available only as options.

If you are upgrading to Oracle8, instead of the Oracle8 Enterprise Edition, you might lose certain options and features that were available to you in the previous release. For further information regarding migration, see Oracle8 Migration.

The following tables explain the features and options in Oracle8 and the Oracle8 Enterprise Edition.

##### Table 3-1 Availability of Oracle8 Features

Feature | Oracle8 | Oracle8 Enterprise Edition | Notes and References
--- | --- | --- | ---
Systems Management and Availability
Enterprise Manager | Y | Y |
Enterprise Manager Performance Pack | N | Y |
Server Managed Backup and Recovery | Y | Y |
Recovery catalog for online backup | Y | Y |
Online recovery | Y | Y |
Incremental backup and recovery | N | Y |
Parallel backup and recovery | N | Y | Oracle8 can only allocate one recovery manager channel at a time, thus limiting the parallelism to one stream. The Oracle8 Enterprise Edition allows unlimited parallelism.
Legato Storage Manager | Y | Y |
Point-in-time tablespace recovery | N | Y |
Fail Safe for Oracle8 on NT | Y | Y | This feature is available on Windows NT.
Datawarehouse/VLDB Features
Bit-mapped indexes | N | Y |
Star Query optimization | Y | Y | In Oracle8, star query processing is the algorithm that utilizes B-tree indexes. In the Oracle8 Enterprise Edition, the parallel bitmap index join algorithm can also be utilized.
Parallel Execution | N | Y |
Parallel Load | N | Y |
Parallel Query | N | Y |
Parallel DML (insert, update, and delete) | N | Y | This feature requires the Partitioning Option.
Parallel index scans | N | Y | This feature requires the Partitioning Option.
Parallel Bitmap Star Joins | N | Y |
Parallel Index Build | N | Y |
Parallel Analyze | N | Y | This feature requires the Partitioning Option.
Programming Interfaces |
Oracle Call Interface | Y | Y |
Objects for OLE | Y | Y |
ODBC driver | Y | Y |
Pro*C/C++ | Y | Y | This feature is available at extra cost as part of Oracle Programmer.
Object Features
object references (REFs) | Y | Y |
object collections | Y | Y |
nested tables | Y | Y |
variable arrays (varrays) | Y | Y |
object views | Y | Y |
Distributed Features
Distributed queries | Y | Y |
Distributed transactions | Y | Y |
Two-phase commit | Y | Y |
XA | Y | Y |
Heterogeneous Services | Y | Y |
Basic Replication | Y | Y |
Read-only snapshots | Y | Y |
Subquery subsetting | Y | Y |
Primary key based snapshots | Y | Y |
Internal triggers | Y | Y |
Replicated LOBs | Y | Y |
Advanced Replication | N | Y |
Updatable snapshots | N | Y |
Multimaster replication | N | Y |
Conflict detection and resolution | N | Y |
Replication Manager | N | Y |
Parallel propagation | N | Y |
Minimized communication | N | Y |
Networking Features
Oracle Names | Y | Y |
Oracle Connection Manager | N | Y |
Connection Pooling | Y | Y |
Connection Multiplexing | Y | Y |
MultiProtocol Connectivity | N | Y |
Oracle Security Server | Y | Y |
Other Features
Advanced Queuing | N | Y | Advanced Queuing supports two types of message payloads-RAW and structured (where the structure is specified by an object type). Without the Objects option, users can only use RAW queues. Both single-consumer and multi-consumer RAW queues are available without the objects option. See Oracle8 Application Developer's Guide for details.
Reverse key indexes | Y | Y |
Password management | Y | Y |
Index-organized tables | Y | Y |
PL/SQL stored procedures, triggers | Y | Y |
INSTEAD OF triggers | Y | Y | This feature can be used with relational views as well as object views. Object capabilities require the Objects option.
External procedures | Y | Y |
National Language Support | Y | Y |
LOB support | Y | Y |
Data Cartridges (extended datatype support; available at extra cost)
ConText Cartridge | Y | Y | The ConText Cartridge offers full text retrieval.
Video Cartridge | Y | Y |
Image Cartridge | N | Y | For more information, see Oracle8 Image Cartridge User's Guide.
Visual Information Retrieval Cartridge | N | Y | For more information, see Oracle8 Visual Information Retrieval Cartridge User's Guide.
Time Series Cartridge | N | Y | Note: To add functions or types to the Time Series Cartridge requires the Objects option. For more information, see Oracle8 Time Series Cartridge User's Guide.
Spatial Data Cartridge | N | Y | For more information, see Oracle8 Spatial Cartridge User's Guide and Reference.

##### Table 3-2 Availability of Oracle8 Options

Feature | Oracle8 | Oracle8 Enterprise Edition | Notes and References
--- | --- | --- | ---
Oracle8 Options (available only for the Oracle8 Enterprise Edition, at extra cost)
Objects Option | N | Y | The Objects option allows data to be represented, accessed, manipulated, and stored as business objects. It allows the definition of object types and all features that use object types, including object tables, object views, the object cache, extended Oracle Call Interface features, the object features of Pro*C, extended SQL and PL/SQL support of object capabilities. No CREATE TYPE, ALTER TYPE, or CREATE OR REPLACE TYPE statements are possible without this option. Note: INSTEAD OF triggers are available with the Oracle8 Enterprise Edition, even without the objects option, and can apply to relational views. Also note that LOBs (large objects) are included in both Oracle8 and the Oracle8 Enterprise Edition.
Partitioning Option | N | Y | The Partitioning option allows the definition of partitions of tables and indexes. This feature is useful for OLTP and Data Warehousing users. Note that this option is required for parallel index scans and parallel DML (insert, update, and delete). Note also that partition views, a feature of Oracle7 release 7.3, is included in the Oracle8 Enterprise Edition without this option. No CREATE PARTITION statements are possible without this option.
Advanced Networking Option | N | Y | The Advanced Networking option provides client/server, server/server network security using encryption and data integrity checking as well as enhanced user authentication services.
Enterprise Manager Performance Pack | N | Y | The Oracle Enterprise Manager Performance Pack provides an advanced set of tools for managing database environments. It consists of six applications for advanced diagnostics, monitoring, and tuning of Oracle environments.
Parallel Server Option | N | Y | The Parallel Server option allows multiple nodes of a loosely-coupled system (such as a cluster or massively parallel platform) to share access to a single database, for increased scalability and availability. It includes client-side failover and, on some platforms, inter-node parallel query.

## The V$OPTION Table

To check the values for different options on your database, query the V$OPTION table:

    SVRMGR> SELECT * FROM V$OPTION;

The response will, of course, vary depending upon the specific installation. A sample result might be:

PARAMETER | VALUE | Explanation
Partitioning | FALSE | These options can be purchased
Objects | FALSE | individually or together, but
Parallel Server | FALSE | only with the Enterprise Edition
Advanced replication | TRUE |
Bit-mapped indexes | TRUE |
Connection pooling | TRUE | All 11 TRUE
Connection multiplexing | TRUE | for the Oracle8
Database queuing | TRUE | Enterprise Edition;
Incremental backup and recovery | TRUE |
Instead-of triggers | TRUE | All 11 FALSE for
Parallel backup and recover | TRUE | Oracle8
Parallel execution (see note below) | TRUE |
Parallel load | TRUE |
Point-in-time tablespace recovery | TRUE |

The above example is an Oracle8 Enterprise Edition installation with no extra options.

Note: Parallel execution means SQL run in parallel. This includes parallel query, parallel DML, and parallel DDL.

The following example shows an Oracle8 Enterprise Edition installation with Oracle Parallel Server and Partitioning options, but without the Objects option.

PARAMETER | VALUE
Partitioning | TRUE
Objects | FALSE
Parallel Server | TRUE
Advanced replication | TRUE
Bit-mapped indexes | TRUE
Connection pooling | TRUE
Connection multiplexing | TRUE
Database queuing | TRUE
Incremental backup and recovery | TRUE
Instead-of triggers | TRUE
Parallel backup and recover | TRUE
Parallel execution | TRUE
Parallel load | TRUE
Point-in-time tablespace recovery | TRUE

## Factoring-Related Error Message

One new error message deals with product factoring. It is:

ORA-00439: feature not enabled: %s

where %s is the name of the feature as it exists in the V$OPTION view in the database. For example:

ORA-00439: feature not enabled: Objects

would occur if you tried to use the CREATE TYPE ... AS OBJECT syntax without having purchased the Objects option.

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index