Please tell me differece between Oracle 9i and 10g in brief

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.

Major differences between oracle9i and oracle10g are: 1. Oracle grid computing - an extension of the clustering feature (real application clusters) 2. Data pump replaces imp utility with impdp - faster data movement with expdp and impdp 3. Dbms_scheduler package replaces dbms_job for scheduling 4. Automatic database diagnostic monitor (addm) 5. New 'drop database' statement 6. New dbms_file_transfer package 7. Flashback operations available on row, transaction, table or database level 8. Ability to undrop a table from a recycle bin 9. Ability to rename tablespaces 10. Ability to transport tablespaces across machine types(e.g windows to unix) 11. Automated storage management (asm) 12. Automatic workload repository (awr) 13. Passwords for db links are encrypted 14. New asmcmd utility for managing asm storage hope this helps! avishek

you can add these to the list

Built-in packages—(DBMS_SCHEDULER, DBMS_CRYPTO, DBMS_MONITOR)
Compile-time warnings
Conditional compilation
Number datatype behaviors
An optimized PL/SQL compiler
Regular expressions
Quoting alternatives
Set operators
Stack tracing errors
Wrapping PL/SQL stored programs

Hi oracle 10g is higher version of oracle 9i, oracle 10g has added a following features transparent data encryption async commits connect role can not only connect passwords for db links are encrypted new asmcmd utility for managing asm storage grid computing - an extension of the clustering feature (real application clusters) manageability improvements (self-tuning features) performance and scalability improvements automated storage management (asm) automatic workload repository (awr) automatic database diagnostic monitor (addm) flashback operations available on row, transaction, table or database level ability to undrop a table from a recycle bin ability to rename tablespaces ability to transport tablespaces across machine types (e.g windows to unix) new 'drop database' statement new database scheduler - dbms_scheduler dbms_file_transfer package support for bigfile tablespaces that is up to 8 exabytes in size data pump - faster data movement with expdp and impdp.