I hope you can connect your Oracle9i database from Oracle10g as the same way how you connect from Oracle10g itself.
But you have to add Oracle9i connection details at your Oracle10g TNSNAMES.ORA file.
Simply you copy any other connection setting and change the name, Sid or source name, host name or ip address.
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.
The oracle 10g and oracle 8i there is a minor difference that is oracle 8i doesn't support flash back command once we drop the table in database the message is table dropped but we can use flashback command we can retrieve the drop table once in database
pls tell me how to run oracle developer suite 10g forms using interent explorer 8 in windows xp3
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...
Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
There are many companies and websites that offer the oracle 10g documentation. The best way to obtain the Oracle 10g documentation is through the official Oracle website.
the full form of 10g in oracle is g=grid computing
In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:http://en.wikipedia.org/wiki/Oracle_Database
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.
Oracle 10g's commands are internal; they have nothing to do with what platform it is running on.
In C language Oracle is developed and after that enhancement is done in Java for 10g and 11g