Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Want Diff. Between 8i Vs 8i Ent
Table 3-1 Availability of Oracle8 Features
Feature Oracle8 Oracle8 Enterprise Edition Notes and ReferencesSystems 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, thuslimiting 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-treeindexes. 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
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.
Paul in VT Received on Mon Aug 09 1999 - 13:11:26 CDT