Shrink Rollback Segments manually

Create table, index UNRECOVERABLE

Subquery in FROM clause (Inline view)

PL/SQL wrapper

PL/SQL Cursor variables

Checksums - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM

Parallel Create Table As (CTAS)

Job Queues - DBMS_JOB

DBMS_SPACE and DBMS_APPLICATION_INFO packages

Sorting Improvements - SORT_DIRECT_WRITES

Oracle 7.1 - May 1994

ANSI/ISO SQL92 Entry Level

Oracle Advanced Replication - Symmetric Data replication

Snapshot Refresh Groups

Parallel Recovery

Dynamic SQL - DBMS_SQL

Parallel Query Options - query, index creation, data loading

Server Manager introduced

Read Only tablespaces

Oracle 7.0 - June 1992

Database Integrity Constraints (primary keys, foreign keys, check constraints, default values)

Stored procedures and functions, procedure packages

Database Triggers

View compilation

User defined SQL functions

Role based security

Multiple Redo members - mirrored online redo log files

Resource Limits - Profiles

Much enhanced Auditing

Enhanced Distributed database functionality: INSERTS, UPDATES, DELETES, 2PC

Incomplete database recovery (e.g. SCN based recovery)

Cost Based Optimizer

TRUNCATE tables

Datatype changes (i.e VARCHAR2, CHAR, VARCHAR)

SQL*Net v2, MTS

Checkpoint process (CKPT)

Data replication - Snapshots

Oracle 8 - 1997

Object Relational database (ORDBMS) features

Object types (not just date, character, number as in v7)

SQL3 standard

Call external procedures

LOB >1 per table

Partitioned Tables and Indexes (new partitioning option)

partitions in multiple tablespaces

export/import inpidual partitions

Online/offline, backup/recover inpidual partitions

merge/balance partitions

Advanced Queuing for message handling

Many performance improvements to SQL/PLSQL/OCI making more efficient use of CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes VARCHAR2)

Parallel DML statements (UPDATE and DELETE)

Connection Pooling (uses the physical connection for idle users and transparently re-establishes the connection when needed) to support more concurrent users.

Improved "STAR" Query optimizer

Integrated Distributed Lock Manager in Oracle PS (as opposed to Operating system DLM in v7).

Performance improvements in OPS - global V$ views introduced across all instances, transparent failover to a new node

Data Cartridges introduced on database (e.g. image, video, context, time, spatial)

Backup/Recovery improvements - Tablespace point in time recovery, incremental backups, parallel backup/recovery. Recovery manager introduced (see RMAN)

Security Server introduced for central user administration. User password expiry, password profiles, allow custom password scheme. Privileged database links (no need for password to be stored)

Fast Refresh for complex snapshots, parallel replication, PL/SQL replication code moved in to Oracle kernel. Replication manager introduced.

Index Organized tables (IOTs)

Deferred integrity constraint checking (deferred until end of transaction instead of end of statement).

SQL*Net replaced by Net8

Reverse Key indexes

Any VIEW updateable (INSTEAD OF triggers on views)

New ROWID format

Oracle 8i (8.1.7) - August 2000

Static HTTP server included (Apache)

JVM Accelerator to improve performance of Java code

Java Server Pages (JSP) engine

MemStat - A new utility for analyzing Java Memory footprints