Re: Oracle database version history
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jan 2004 22:23:52 -0700
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@xxxxxxxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
