| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle database version history
Great info!!! Of course you can't list everything or it would have been a
few pages, but I liked the introduction of in-line views. I know they were
there in a point release before they were officially mentioned and
supported, and I think it was 7.1 when they were there, and 7.2 when they
became official?
Regards,
Larry G. Elkins
elkinsl_at_flash.net
214.954.1781
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Gorman
> Sent: Thursday, January 29, 2004 11:24 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Oracle database version history
>
>
> 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
> -----------------------------------------------------------------
>
-- 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:56:43 CST
 |
 |