Differences between 9i and 10g

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database installation, upgrades and patches Oracle's Java database continues push into embedded database market How to use the Oracle Database Upgrade Assistant (DBUA) Oracle delivers database fixes in Critical Patch Update How to get the most out of Toad for Oracle 10 Coca-Cola Bottling swaps out Oracle for DB2 Oracle renews push into embedded open source software market Oracle releases new database, says 11g upgrade will cut costs Comparing servers for Oracle database 11g upgrades Choosing the right server hardware is all about choosing the right software The best of the Oracle 11g-ready servers Why upgrade to Oracle 10g? Questions about Oracle 9i to Oracle 10g upgrade Advantage of migrating to Oracle 10g Functional advantages of 10g over 8i Advanced features of Oracle 10g 'Unlearning' with Database 10g Release 2 Database 10g Release 2 preview

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary 10g  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

The differences between 9i and 10g are too numerous to list here. The best place to look for documentation on 10g's new features is Oracle Technology Network. You will find complete documentation for Oracle 10g on Oracle's Web site, but the two documents that will be of most interest to you are:

Oracle Database New Features Guide 10g Release 2 (10.2)

Oracle Database Upgrade Guide 10g Release 2 (10.2)

In terms of testing, you will want to test your entire upgrade process from start to finish in a development environment several times. You will also want to have your application support team(s) thoroughly test their applications after the upgrade, and I would also recommend getting the business users involved in the testing process.