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