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: <mkline1_at_comcast.net>
Date: Fri, 30 Jan 2004 16:10:44 +0000
Message-Id: <013020041610.21994.3038@comcast.net>


Brings back memories of 4.1.0 that ran on 512k and 4.1.1(I think) that ran on 640k.

And I remember when "Dr. DBA" used to make house calls and come and "visit" all the time to help with a project I was working on. We built a "distributed order entry" system before sql*net. Mind you it only communicated over night, but it was a big improvment over what they had. About 21 PCs running DOS and a mini VAX, maybe a 750?

--
Michael Kline, Principle Consultant
Business To Business Solutions
13308 Thornridge Ct
Midlothian, VA  23112
804-744-1545

> 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
> -----------------------------------------------------------------
---------------------------------------------------------------- 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 - 10:10:44 CST

Original text of this message

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