Re: Oracle database version history

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 29 Jan 2004 22:23:52 -0700
Message-ID: <BC3F3878.F616%tim@sagelogix.com>

How the heck did Tanel manage to learn so much after being born in 1978? Because he didn't have to listen to disco... :-)

on 1/29/04 7:19 PM, Mladen Gogala at mgogala_at_adelphia.net wrote:

> 
>> Oracle 5 - 1986
>>  - Client Server
>>  - Cluster support (VAX)
> 
> Nope. Cluster  wasn't supported with V5. Cluster support
> came with  Oracle 6.2. That was the first OPS version and
> was VAX/VMS-only.

[TG]: Mladen, sorry to contradict, but Tanel is correct. V5 had the first clustered database on VAX/VMS. Wasn't pretty, but it had a pulse...

V6.2 was indeed the first version of the Parallel Server product, available originally on VAX/VMS and later on NCR Unix. Had a financial services company here in Denver using V6.2 OPS on NCR (crazy bahstahds). Naturally, I wanted to hire the DBA out of sheer admiration...

> 
> 
>> 
>> Oracle 6 -1989
>>  - Online backup & recovery
>>  - Row level locking, stored PL/SQL
> 
> Nope. PL/SQL  wasn't stored in V6, it was executed in SQL*Forms30,
> if anyone still remembers the good, old INP files instead of the
> stupid *.FMB stuff.

[TG]: Sorry to contradict both of you, but the PL/SQL that was available in the database server was not stored, and it wasn't only available in SQL*Forms. It was available in the database server as "anonymous" blocks (i.e. starting with BEGIN or DECLARE keywords) in v6. In v7 came packages, procedures, and functions; in v6, you created big ol' SQL*Plus scripts to run them the "anonymous" blocks.

Mladen is correct that procedures in PL/SQL were available in SQL*Forms v3.0 and SQL*ReportWriter v1.x also, on the client side...

> 
>>  - Parallel Server
>> 
>> The rest you know ;)

Well, for those who don't know, here are some more milestones...

More for Oracle6 (1989):

hot backups (not certain about this -- could have been v5)

v7.0 (1992):

basic replication (a.k.a. snapshots)
stored PL/SQL packages, procedures, and functions
database triggers
direct-path SQL*Loader
cost-based optimizer
the Shared Pool in the SGA

v7.1 (1994):

parallel queries
parallel direct-path SQL*Loader
parallel index creation
parallel instance recovery
Symmetric (multi-master) replication
the Large Pool in the SGA

V7.2 (1995):

parallel CREATE TABLE AS SELECT

v7.3 (1996):

parallel INSERT /*+ APPEND */
bitmap indexes
partition UNION-ALL views
ALTER INDEX REBUILD
Oracle Enterprise Backup Utility (OEBU)
Standby Database

v8.0 (1997):

range partitioning
Recovery Manager (RMAN)
INSTEAD OF triggers on views
REVERSE indexes
parallel UPDATE and DELETE

v8.1 (1999):

hash partitioning
composite range-hash subpartitioning
DDL and database-event triggers
materialized views and query rewrite
function-based indexes

...to name a few...

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jan 29 2004 - 23:23:52 CST