• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 21150
  • Last Modified:

DIFFERENCE BETWEEN ORACLE 8i,9i,10g

Hello,

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

Thanks
0
talentium
Asked:
talentium
  • 2
1 Solution
 
paquicubaCommented:
8i < 9i < 10g
0
 
meluhkCommented:
This is a very broad question.  There are volumes of data on each of these versions.  I suggest that you go to

http://tahiti.oracle.com/pls/tahiti/tahiti.homepage  for Oracle 8i
http://otn.oracle.com/pls/db92/db92.homepage for Oracle 9i
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=1 for Oracle 10g

Happy reading!

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

0
 
paquicubaCommented:
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:
http://www.oracle.com/pls/tahiti/homepage?remark=tahiti

9.0.1 Documentation (New Features) :
http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90120/toc.htm

9.2 Documentation (New Features) :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96531/toc.htm

10.1 Documentation (New Features) :
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10750/toc.htm

10.2 Documentation (New Features) :
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14214/toc.htm



+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Oracle9i New Features for Oracle8i DBAs:

http://www.dbspecialists.com/presentations/oracle9i_new_features.html


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

http://www.oracle.com/technology/pub/articles/10gdba/index.html
0
 
haidersyedCommented:
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

However

 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


0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now