A lot of differences this is my take on them:
8i -> 9i - Real Application Clusters, PL/SQL enhancements, XMLType enhancements
9i -> 10g - ASM space management, tracing and diagnostics, DML error logging, async commit, more PL/SQL changes, table/column encryption, restore points
10g -> 11g - Probably best to point you to technet on that one.
Hioralce 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.
Regards Rampoo
Oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump.
Generating snap shot is much more flexible in 10 g compare to 9i.
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.
The "i" and "g" Versions
Starting in 1999 with Version 8i, Oracle added the "i" to the version name to reflect support for the internet with its built-in Java Virtual Machine (JVM). Oracle 9i added more support for XML in 2001. In 2003, Oracle 10g was introduced with emphasis on the "g" for grid computing, which enables clusters of low-cost, industry standard servers to be treated as a single unit.
10g is Oracle's grid computing product group including (among other things) a database management system (DBMS) and an application server. In addition to supporting grid computing features such as resource sharing and automatic load balancing, 10g products automate many database management tasks. The Real Application Cluster (RAC) component makes it possible to install a database over multiple servers.
10g follows Oracle's 9i platform. Oracle says that the g (instead of the expected i) in the name symbolizes the company's commitment to the grid model. However, according to some reports, many early adopters are deploying 10g solely for its automation features and have no immediate plans of implementing a grid environment.
storage is different as compared 9i with 10i.........10i uses grid computing...this has more data storage space
The simple answer is that Oracle 10g is a real product from Oracle. Oracle 11i does not exist; the Oracle product is Oracle 11g.
no. of database rules they follow.
what is difference between oracle 9i and oracle 10g what is difference between oracle 9i and oracle 10g What is the Full form of "i" in Oracle 9i What is the Full form of "g" in Oracle 10g ans =the oracle 9i the "i" is stands for internet and oracle 10g the " g" stands for grid and new version of oracle 11g was launch in 2007 it provided the special feature rather 8i ,9i other it have a RAC, and network security etc. and good for organization purpose .
Oracle 8i and 9i were databases with 'i' referring to the Internet. For version 10 onwards, Oracle named the database as 10g, 'g' referring to the grid. 10i and 11i are ERP systems, nothing to do with the database.
in 10g sysaux is new tablespace is present in 9i it is now present while in import and export any database in 10g impdp and expdp (data pump ) like facility is present
G signifies "Grid Computing"... With the release of Oracle 10g in 2003, Oracle changed the suffix in their previous release version; from 9i to 10g... 'I' stands for Internet...this was done as a marketing effort in order to show Oracle's move towards Grid Computing... Purely a marketing strategy...
The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....
There are various versions of oracle like 9i, 10g, 11g, 12c etc. Oracles 10 g version was specifically designed to support grid format .
Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.
'i' in oracle 9i stands for internet
A person can download updates to Oracle 9i directly from the website. The only place that allows a person to download Oracle 9i is from the Oracle website.
Both of them are application development tools from Oracle One of the difference is Oracle forms 4.5 uses two tier technology ie it is client server based. It needs the Oracle client to run Oracle forms 9i uses uses three tier technology ie the application developed using it runs on an internet brower.
Oracle is a Relational DataBase Management System Software (RDBMS) Oracle Application is a s/w that Operates on the Data Existed in the DataBase. e.g:- Oracle 8i,9i,10g,11g are DataBases. Oracle Fusion,Siebel CRM etc. are Applications. Simple Scenario where exactly we found the differences b/w these two:- ================================================== For example,the Data Related to Customers of a Bank is Stored inside the DataBase(either 10g,8i,or 9i) and after every month the Bank has to Generate the Reports for each Customer in word (or) PDF (or)html exactly in this scenario the Oracle Application(11i,12i) comes into the Picture it Generates the Reports based on the DataStored inside the DataBase by connecting to the DataBase.
what is mean by oracle? == ==