Is it possible to run an export from a database using the exp utility on a different database? If I have a new database up and running on a new server, can i go to that new server and run something like exp myname/myname@remoteserver tables=mytable? I tried it and got tns errors even though the "remoteserver" is set up properly in tns on the new server. Im guessing that its not possible and dont want to waste any more time if this is a dead end.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can you run exp or imp on machine that db is not on 1
- Thread starter bookouri
- Start date
-
1
- #2
Hi,
It is certainly possible ( we export from all our databases on many servers from one central client machine..The 'gotcha' is that the version EXP must match the version of the exported database.
What errors did you get?
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
It is certainly possible ( we export from all our databases on many servers from one central client machine..The 'gotcha' is that the version EXP must match the version of the exported database.
What errors did you get?
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Thread starter
- #3
SantaMufasa
Technical User
Slight adjustment for the sake of completeness "...must match the version of, or be an earlier version than, the exported database.Turkbear said:
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
Hi,
As usual, good catch, Santa...
BTW, bookouri, you can install an 9i client on your 10g client machine and, by going to its home/bin directory and running your EXP from there, all should be well..
To Paraphrase:"The Help you get is proportional to the Help you give.."
As usual, good catch, Santa...
BTW, bookouri, you can install an 9i client on your 10g client machine and, by going to its home/bin directory and running your EXP from there, all should be well..
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Thread starter
- #6
As Always, then are a few issues with that:
The 9i client install may change your default Oracle_Home ..be sure to reset it to the 10g home..
( when using the EXP for 9i, as long as you are in the <Oracle9i_Home>/bin directory, it will not 'care' about the default home..But some 10g apps may mind if the default it not set to it..)
One more thing to make it easier to manage 2 clients:
Create a system Environment variable called TNS_ADMIN and set it to your <Oracle10g_Home>/Network/admin directory..that way you need only maintain 1 tnsnames.ora file...
To Paraphrase:"The Help you get is proportional to the Help you give.."
The 9i client install may change your default Oracle_Home ..be sure to reset it to the 10g home..
( when using the EXP for 9i, as long as you are in the <Oracle9i_Home>/bin directory, it will not 'care' about the default home..But some 10g apps may mind if the default it not set to it..)
One more thing to make it easier to manage 2 clients:
Create a system Environment variable called TNS_ADMIN and set it to your <Oracle10g_Home>/Network/admin directory..that way you need only maintain 1 tnsnames.ora file...
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Status
Similar threads
