Re: Oracle 6 vs 7

From: Roderick Manalac <rmanalac_at_oracle.COM>
Date: Fri, 19 Feb 1993 03:36:24 GMT
Message-ID: <1993Feb19.033624.12595_at_oracle.us.oracle.com>


mazumdar_at_ringer.cs.utsa.edu (Subhasish Mazumdar) writes:
|> It would be very helpful if someone could
|> summarize the principal differences between 6.0 and 7.x.
|>

The best summary of the differences between V6 and V7 can be found in Oracle7 Server Migration Guide. Most of the differences are added functionality in V7.

Some Highlights:
Enforced integrity constraints at the database level Extended national language support.
Stored PL/SQL procedures and functions
Two-phase commit
Snapshots
Support for TP monitors
Parallel Server now also available on certain Unix platforms Mirrored on-line log files.
More granular system priveleges
Support for roles
Multi-threaded server support
Cost based optimization
Hash cluster support
A menu-driven SQL*DBA utility
VARCHAR2 strings of up to 2000 characters LONG and LONG RAW now support objects upto 2Gig in length

Hope this helps.

Roderick Manalac
Oracle Corporation Received on Fri Feb 19 1993 - 04:36:24 CET

Original text of this message