RE: Oracle database version history
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jan 2004 06:19:12 -0800
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Friday, January 30, 2004 4:52 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxx]
Sent: Friday, January 30, 2004 5:48 AM
To: oracle-l@xxxxxxxxxxxxx
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@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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe'
in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
