Solved

import DB when multiple oracle versions same server

Posted on 2011-03-02
7
654 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
7 Comments
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
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 73

Accepted Solution

by:
sdstuber earned 250 total points
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
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 68

Expert Comment

by:Qlemo
Comment Utility
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 76

Expert Comment

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

Author Closing Comment

by:C2enterprise
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle SQL Syntax 8 56
adding % symbol to a percentage - oracle query 16 39
Cannot open form error 6 46
sql query 5 51
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now