| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_SLAC.Stanford.edu
>
> -----Original Message-----
> From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]
> 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... :-)
> >
> >
> > 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 - 09:17:20 CST
 |
 |