DIFFERENCE BETWEEN ORACLE 8i,9i,10g

Hello,

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

Thanks
talentiumAsked:
Who is Participating?
 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.