| Import to remote server [message #200839] |
Wed, 01 November 2006 09:51  |
manger
Messages: 1
Registered: November 2006
Location: Sweden/KNA
|
Junior Member |
|
|
Hey all, is there anyway to import dumpfiles to a remote server?
I've got me a bunch of .dmp files (liferay, jforum, corendal wiki)from oracle 10g and I've been assigned a table-space on a new oracle server. I don't have any details about the connection to the oracle server yet, but I'm supposed to run these old tables on the new server.
The thing is that I don't have physical access to this new server, and I don't think I'll get SSH/termsrvr either.
Found a snippet of someone using the export command to export from a remote server:
exp dbaUser/password@remotedb owner=scott file=scott.dmp
Can I use the import command the same way?
Is there any other way of doing this? Perhaps using data pump, but that would require me to convert my existing .dmp files, which I don't know how to do either.
Tried searching, found a lot, didn't help...
Thanks y'all 
|
|
|
|
|
|
|
|
| Re: Import to remote server [message #200854 is a reply to message #200839] |
Wed, 01 November 2006 12:02  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Additionally to what the others have said, if export file is big, an import across a TNS connection can be painfully slow. you'll need to know a username and password on the remote server to be able to import unless they want you to put it in SCOTT.
[Updated on: Wed, 01 November 2006 12:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
