RE: List out differences between Oracle Server 9i and Oracle Server 10g.
10 G supports grid computing ASM (Automatic storage management) and Memory management.
Oralce 10g is higher version of 9i Oracle 10g has added a follwoing 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.
In Oracle 9i after drop we can't rollback but we can do it in 10g. Moreover 10g has additional 149 features than 9i.