They didn't "skip" 6.1; I believe that it was a version specific to some modifications for a single project at AT&T... on 1/30/04 5:51 AM, Mercadante, Thomas F at thomas.mercadante@xxxxxxxxxxxxxxxxx wrote: > 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 -----------------------------------------------------------------