Re: Oracle database version history

hot backups were version 6 not 5... 6 was a major rewrite... introduced
rollback segments, tablespaces


--- Tim Gorman <tim@xxxxxxxxxxxxx> 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@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 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: