RE: Oracle database version history

I recall being charged extra for PL/SQL when we purchased 7.0.12

Jared

On Fri, 2004-01-30 at 06:19, MacGregor, Ian A. wrote:
> 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 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------

----------------------------------------------------------------
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: