Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle database version history

Re: Oracle database version history

From: Tim Gorman <tim_at_sagelogix.com>
Date: Fri, 30 Jan 2004 06:29:51 -0700
Message-ID: <BC3FAA5F.F64C%tim@sagelogix.com>


They didn't "skip" 6.1; I believe that it was a version specific to some modifications for a single project at AT&T...

on 1/30/04 5:51 AM, Mercadante, Thomas F at thomas.mercadante_at_labor.state.ny.us wrote:

> Version 6 did so have stored PL/SQL.  I know I created many many stored
> packages, procs and functions in 6.2.  And I also used OPS in a VAX cluster
> (two Vax servers, one database).  Ran just fine, thank you.
> 
> And why did Oracle go from version 6.0 directly to 6.2 (skipping 6.1)?
> Anybody?
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: Friday, January 30, 2004 5:48 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Oracle database version history
> 
> 
> hot backups were version 6 not 5... 6 was a major rewrite... introduced
> rollback segments, tablespaces
> 
> 
> --- Tim Gorman <tim_at_sagelogix.com> wrote:

>> 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
>> -----------------------------------------------------------------
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------

----------------------------------------------------------------
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 Fri Jan 30 2004 - 07:29:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US