RE: Oracle database version history

From: Glenn Travis <Glenn.Travis_at_sas.com>
Date: Fri, 30 Jan 2004 09:27:11 -0500
Message-ID: <C99BC7A327FD4049BA8F57DDAAF0E4E709725A3B@merc11.na.sas.com>

http://www.oracle.com/cluboracle/index.html?screensavers.html

Select the 'Oracle Defining Moments - 25 Years of Technology Innovation' = screen saver...

-----Original Message-----
From: MacGregor, Ian A. [mailto:ian_at_SLAC.Stanford.EDU]=20 Sent: Friday, January 30, 2004 9:19 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Oracle database version history

As I recall the in 6.0 the TPO, Transaction Processing Option, became = part of the core product and not an extra cost add-on. Those sites = which had TPO previously were given the procedural option for free, = those which did not have TPO previously had to pay for the procedural = option.

Declarative constraints were introduced in v6, but they were not fully = functional. You could not drop a table which had a primary column = referenced by a foreign key column, but you could delete rows in the = primary key table which were referenced by rows in the foreign key = table. The referential integrity documentation did not acknowledge = this. It was written as if RI was fully functional

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]=20 Sent: Friday, January 30, 2004 4:52 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Oracle database version history

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... :-)
>=20 >=20
> on 1/29/04 7:19 PM, Mladen Gogala at mgogala_at_adelphia.net wrote:
>=20
> >=20
> >> Oracle 5 - 1986
> >> - Client Server
> >> - Cluster support (VAX)
> >=20
> > 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.
>=20
> [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=20
> pulse...
>=20
> V6.2 was indeed the first version of the Parallel Server product,
> available originally on VAX/VMS and later on NCR Unix. Had a=20
> financial services
> company here in Denver using V6.2 OPS on NCR (crazy bahstahds).=20
> Naturally,
> I wanted to hire the DBA out of sheer admiration...
>=20
> >=20
> >=20
> >>=20
> >> Oracle 6 -1989
> >> - Online backup & recovery
> >> - Row level locking, stored PL/SQL
> >=20
> > 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=20
> > stupid *.FMB stuff.
>=20
> [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=20
> available in SQL*Forms. It was available in the database server as=20
> "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.
>=20
> 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...
>=20
> >=20
> >> - Parallel Server
> >>=20
> >> The rest you know ;)
>=20
> Well, for those who don't know, here are some more milestones...
>=20
> More for Oracle6 (1989):
>=20
> - hot backups (not certain about this -- could have been v5)
>=20
> v7.0 (1992):
>=20
> - 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
>=20
> 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
>=20
> V7.2 (1995):
> - parallel CREATE TABLE AS SELECT
>=20
> v7.3 (1996):
> - parallel INSERT /*+ APPEND */
> - bitmap indexes
> - partition UNION-ALL views
> - ALTER INDEX REBUILD
> - Oracle Enterprise Backup Utility (OEBU)
> - Standby Database
>=20
> v8.0 (1997):
> - range partitioning
> - Recovery Manager (RMAN)
> - INSTEAD OF triggers on views
> - REVERSE indexes
> - parallel UPDATE and DELETE
>=20
> v8.1 (1999):
> - hash partitioning
> - composite range-hash subpartitioning
> - DDL and database-event triggers
> - materialized views and query rewrite
> - function-based indexes
>=20
> ...to name a few...
>=20
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 08:27:11 CST