What is the difference between Oracle 9i and Oracle 8i?
Oracle 8i and 9i are different versions of the database. It's like asking what's the difference between Windows 95 and Windows 98! With Oracle each new version contains the same functionality as the previous version. So Oracle 9i is backwards compatible with 8i. Oracle 9i does many things differently internally so they are not exactly the same database engine. And Oracle 9i has a host of new features designed to make the database more stable, easier to manage and increase functionality. There are so many new features that Oracle Corp. provides a complete manual listing these new feature. The Oracle 9i New Features manual can be found on Oracle's Technet site at http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90120/toc.htm if you are interested. You will need to register for a free account if you want to view documentation on that site.
For More Information
- What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.