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
-----------------------------------------------------------------
Received on Fri Jan 30 2004 - 06:51:36 CST
