Re: Differences from 7.0 to 7.3 ???

In article <5fv2r9$14k_002_at_news.ici.net> david_at_pencilnet.com (David Ehrens) writes:
>I am using Personal Oracle 7.3 (Win95) to learn, and will shortly start work
>on a project which uses Oracle 7.0 (VMS).
>
>What's NEW since 7.0? As I learn 7.3, I'd like to make a mental note of
>features that may not be backwards compatible to the version I'll be using for
>production.
>
>Thanks & Regards,
>
>-----
>David Ehrens - PencilNet, Inc. - http://www.pencilnet.com
>Networking & Systems Integration - david_at_pencilnet.com

There are many significant differences. The biggest one in my view is the improvement in the handling of extents (less a problem on VMS than on unix environments). SQLDBA replaced by svrmgr is another biggie. You will need a pc (or nc) to deal with Oracle.

There are lots of changes, too many too reel off the top of my poor aching head, but I have some docs to hand to give some ideas. Note that to go to 7.3 you'll have to go to VMS 7, too. If you know anyone with later versions of Oracle, ask to see their readme under the [.rdbms] account for the gory details.

Oracle 7.1 on VMS:

Read-only tablespaces
Multiple same-type triggers per table
Server Manager
Export/Import incompatabilities for certain objects. Truncate command

7.2:
PL/SQL behavior changes
Lots of bugfixes

In the parallel server for 7.3 alone:

Deferred Transaction Recovery
Instance Registration
Load Balancing via Multiple SQL*Net listeners Disk Affinity
Fine Grained Locking (releaseable locks) Dedicated Temporary tablespaces
Partition Views
Parallel Aware optimization

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O