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 |
|
|
Y |
Y |
|
object views |
Y |
Y |
|
Distributed Features |
Distributed queries |
Y |
Y |
|
Distributed transactions |
Y |
Y |
|
|
Y |
Y |
|
|
Y |
Y |
|
Heterogeneous Services |
Y |
Y |
|
Basic Replication |
Y |
Y |
|
|
Y |
Y |
|
|
Y |
Y |
|
|
Y |
Y |
|
|
Y |
Y |
|
|
Y |
Y |
|
Advanced Replication |
N |
Y |
|
|
N |
Y |
|
|
N |
Y |
|
|
N |
Y |
|
|
N |
Y |
|
|
N |
Y |
|
|
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 |
N |
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. |