Re: Best version to buy?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 13 Jul 1999 20:23:04 +0200
Message-ID: <931890152.14673.0.pluto.d4ee154e@news.demon.nl>

Hi Ted,

Main difference between Oracle 7 and Oracle 8 is

- different rowid format
- partition options added
- advanced queing mechanism added
- sqlnet 2 replaced by net 8
- administrative changes

Oracle 8i adds some 150 new features including a JVM in Oracle and lots more.
It looks like Oracle 8i is a kind of side-grade, you could look at it as a new product, focusing on Internet functionality which you may not need as long as you use Oracle Applications 10.7. This means 11: yes...
If you create a database using Oracle 8i, you will not be able to use it with Oracle 7.3, ie you cannot downgrade the database. You can connect Oracle 7 software to it, that will work. I would probably go for 7.3.4. At least we know that product is stable.

Of course this is all IMO.

Hth,

Sybrand Bakker, Oracle DBA

Ted Brooks <tbrooks_at_ibm.net> wrote in message news:378abe85_at_news1.us.ibm.net...
> Hi! I am looking to purchase a version of Personal Oracle for Win 98 for
> self-training. While my initial reaction would be to buy the latest and
> greatest (8i), I need to be able to support 7.3.4, as my company just
> implemented Applications 10.7 on this database version. What are the
major
> differences between the versions? If each one is an improvement, why does
> Oracle still market all three versions (7,8,and 8i)? And If I did
purchase
> and create databases using 8i, will they be compatible with my 7.3.4
> enterprise system?
> Bottom line: Which one should I buy??
> Sorry for the newbie question, but I am relatively new to the world of
> oracle!! Thanks.
>
>
Received on Tue Jul 13 1999 - 13:23:04 CDT