3
Differences between Oracle8 and the Oracle8 Enterprise Edition

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.  

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.