Posted on 2006-05-09
Last Modified: 2012-08-13

Can you explain me the difference between oracle 8i and 9i and 10g also.

Question by:talentium
    LVL 23

    Expert Comment

    8i < 9i < 10g
    LVL 4

    Expert Comment

    This is a very broad question.  There are volumes of data on each of these versions.  I suggest that you go to  for Oracle 8i for Oracle 9i for Oracle 10g

    Happy reading!

    If you have more specific question regarding this subject, you might try to open another question and refine it.

    LVL 23

    Accepted Solution

    The best way to know the differences is using the New Features Books. Below are the links to the books and a couple of helpful sites:

    8.1.7 Documentation:

    9.0.1 Documentation (New Features) :

    9.2 Documentation (New Features) :

    10.1 Documentation (New Features) :

    10.2 Documentation (New Features) :


    Oracle9i New Features for Oracle8i DBAs:

    Oracle Database 10g: The Top 20 Features for DBAs:
    LVL 3

    Expert Comment

    There are hundared of new features in every version
     you can look it in two aspects

     1- Technical
     2- Product business usage

    You have to go through new features papers for this


     oracle 8i was  first improved version or oracle 8 which have lot of java based features including built in java engine within database improved partitioning options , lot of data warehouse and little touch of XML Type things. Idea of e-commerce included in database.

    Oracle 9i added idea of somewhat pure m-commerce database with lot of data warehouse feature , improved sql feature , xml based improvement , enhance application server , oracle spatial and domain index improvement , Enhanced feature of RMAN and backup and recovery options etc.

    This is not complete details or comparison just a summary

    Haider Ali Syed
    Sr. IT Exective Databases


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to recover a database from a user managed backup

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now