Solved

import DB when multiple oracle versions same server

Posted on 2011-03-02
7
666 Views
Last Modified: 2012-05-11
Hi Experts,

      I don’t know the difference between 11g and 11gr2 but they ask me to install the new version..  No box left, so I installed it on my 11g  server.  I can communicate with both database without problem.  My question is, normally when I import a dump, I’m using this command; IMP system/Password  file=c:\dump.dmp fromuser=SchemaUser touser=My_user ignore=yes log=c:\nom_log.log

I already import a dump to our 11gr2, but now, I need to import a dump on the 11g database. How can a select which version of oracle I want to import it too. ?  Any switch to add?

Thanks,
0
Comment
Question by:C2enterprise
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 35019308
always import with the SAME version of "imp" as the target db.

always export with the LOWEST version of "exp" of either the source or the target.

So, if you are moving from 11gR1 to 11gR2  then use 11gR1 exp  and 11gR2 imp

if you are moving from 11gR2 to 11gR1 then use 11gR1 for both exp and imp
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 total points
ID: 35019316
you choose which by adjusting the PATH to whichever oracle home corresponds to the version you want to use.

Or run it explicitly with fully qualified path  something like...  /oracle/product/11.1/bin/imp
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35019324
You also need to set up the tnsnames.ora file for the version of imp you are using to be able to see the other version.

Then on import: useername/password@dbalias_from_tnsnames
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 74

Expert Comment

by:sdstuber
ID: 35019363
since you are working with 11g,  you should also get used to using the new datapump (dp) versions


expdp and impdp

but, if you have older exp dump files, it's safe (and required) to use the 11g imp for them, but it's recommended practice to use the new dp versions going forward
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 35019393
To make sure you are using the right version each time, you should create shortcuts, executing
    cmd /k cd «YourOracleBinPathHere»
or at least
    cmd /k set path=«YourOracleBinPathHere»;%PATH%
for each release you install, and then use the corresponding Command prompt to execute. Of course you can set up other vars, too, like ORALE_HOME and TNS_ADMIN, but that should not be necessary.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35019401
The main negative for datapump is the ability to create a DMP file on a remote machine.
0
 

Author Closing Comment

by:C2enterprise
ID: 35019751
Other solution are certainly good..  but this one is the easier for us that doesn't really use oracle except for debugging.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help on decision table structure 7 58
Select the 2 most recent visit dates 5 31
Age Calculation from specific date 19 59
Errror when importing data from Oracle to SQL 6 68
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question