0
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.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is the difference between Oracle 10i and Oracle 10g?
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.
What is all about oracle 10g and oracle8i?
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
Can oracle form 10g run on internet explorer 8?
pls tell me how to run oracle developer suite 10g forms using interent explorer 8 in windows xp3
What is the meaning of g in oracle 10g?
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...
How much data store in oracle database?
Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.
What are the differences between Oracle 10g and ms sql database?
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
Where can one find the Oracle 10g documentation?
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.
Full form of 10g in oracle?
the full form of 10g in oracle is g=grid computing
What is the difference between Oracle Database and an Oracle application?
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.
Why is Oracle 10g named so?
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
How do you install Oracle 10g in Windows XP?
A detailed step of Installation process with screenshot is discussed in the following website, http://oracledba-vinod.blogspot.com/2009/12/install-oracle-10g-on-windows-xp-using.HTMLThanksVdhanInstalling Oracle 10g - step by step guideIntroduction:This article is a step-by-step instruction for those who want to install Oracle 10g database on their computer. This document provides guidelines to install Oracle 10g database on Microsoft Windows environment. If you use other operating system other than Microsoft Windows, the process is not too much different from that of Microsoft Windows, since Oracle uses Oracle Universal Installer to install its software.For more information about installing Oracle 10g under operating systems other than Microsoft Windows, please refer to this URL :http://www.oracle.com/pls/db102/homepageHow to get Oracle 10g :You can download Oracle 10g database from www.oracle.com. You must registered and create an account before you can download the software. The example in this document uses Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows. How to uninstall Oracle database software :Uninstall all Oracle components using the Oracle Universal Installer (OUI).Run regedit.exe and delete the HKEY_LOCAL_MACHINE/ SOFTWARE/ORACLE key. This contains registry entire for all Oracle products.Delete any references to Oracle services left behind in the following part of the registry: HKEY LOCAL MACHINE/ SYSTEM/ CurrentControlsSet/ Services/Ora*. It should be pretty obvious which ones relate to OracleReboot your machine.Delete the C: \Oracle directory, or whatever directory is your Oracle_Base.Delete the C:\Program Files \Oracle directory.Empty the contents of your c:\temp directory.Empty your recycle bin.Installing Oracle 10g database software :Insert Oracle CD , the autorun window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder.The Oracle Universal Installer (OUI) will run and display the Select Installation Method Window.Choose Basic Installation:Select this option to quickly install Oracle Database 10g. This method requires minimal user input. It installs the software and optionally creates a general-purpose database based on the information you provide.For basic installation, you specify the following:Oracle Home Location - Enter the directory in which to install the Oracle Database 10g software. You must specify a new Oracle home directory for each new installation of Oracle Database 10g. Use the default value, which is :c:\oracle\product\10.2.0\db_1Installation Type - Select Enterprise Edition :If you have limited space, select standard edition. Personal edition installs the same software as the Enterprise Edition, but supports only a single-user development and deployment environment.Create Starter Database - Check this box to create a database during installation. Oracle recommends that you create a starter database for first Create Starter Database - time installations. Choose a Global Database Name, like cs157b, or just use the default value.Type a password. Don't lose this password, since you will need it to connect to the database server.Click nextThe Product-Specific Prerequisite Checks window appears: Click nextA summary screen appears showing information such as your global settings, space requirements and the new products to be installed. Click Install to start the installation..The Install window appears showing installation progress.At the end of the installation phase, the Configuration Assistants window appears. This window lists the configuration assistants that are started automatically. If you are creating a database, then the Database Configuration Assistant starts automatically in a separate window.At the end of database creation, you are prompted to unlock user accounts to make the accounts accessible. The SYS and SYSTEM accounts are already unlocked. Click OK to bypass password management.Note: Oracle 10g still keeps Scott / tiger username and password (UID=Scott, PWD=tiger) from the old version of oracle. In the old version of oracle, Scott/tiger user ID is available by default, but not in oracle 10g. If you want to use Scott /tiger account, you must unlock it by clicking "Password Management" at the last window.Password Management window will appear like the one shown below. Find the user name "Scott" and uncheck the "Lock Account?" column for the user name.Your installation and database creation is now complete. The End of Installation window displays several important URLs, one of which is for Enterprise Manager.You can navigate to this URL in your browser and log in as the SYS user with the associated password, and connect as SYSDBA. You use Enterprise Manager to perform common database administration tasks Note : you can access Oracle Enterprise Manager using browser by typing the URL shown above in your browser. Instead of typing the IP address, you can also access the Enterprise Manager by typing http://localhost:1158/em or "http://[yourComputerName]:1158/em" or by clicking "Start >> All Programs >> Oracle - [YourOracleHome_home1] >> Database Control - [yourOracleID]" in Windows menu.By default, use user ID "SYSTEM", with the password that you have chosen at the beginning of installation, to connect to database, SQLPlus, etc. If you want to use other user ID, you may create a new user .
Is Oracle a programming language?
In C language Oracle is developed and after that enhancement is done in Java for 10g and 11g
