Home » RDBMS Server » Server Utilities » Export Test database to remote windows location (oracle 10.2.0.1.0,Redhat Linux 4)
Export Test database to remote windows location [message #434383] Wed, 09 December 2009 02:00 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear All,

i would like to take dump backup of test database to remote location(windows), but i mentioned my oracle version and OS already

thanks in advance
Re: Export Test database to remote windows location [message #434388 is a reply to message #434383] Wed, 09 December 2009 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup or export?
What is your problem doing an export remotly?

Regards
Michel
Re: Export Test database to remote windows location [message #434390 is a reply to message #434388] Wed, 09 December 2009 02:24 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks Michel,

as i m getting disk space problem, i would like to take daily export backup of test database to another system (windows OS.)
Re: Export Test database to remote windows location [message #434391 is a reply to message #434388] Wed, 09 December 2009 02:28 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
i need procedure to do export to the remote computer(windows), my database working in linux system

please give me the source code for export
Re: Export Test database to remote windows location [message #434392 is a reply to message #434391] Wed, 09 December 2009 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the same than with a local export except that you give a remote connection string instead of a local one that is the same connection string that you give to remotely connect with SQL*Plus.

Regards
Michel
Re: Export Test database to remote windows location [message #434394 is a reply to message #434392] Wed, 09 December 2009 02:38 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Sorry Mr.Michel

i could not understand, please give me an example if you are free
sorry for unaware of these things
Re: Export Test database to remote windows location [message #434395 is a reply to message #434394] Wed, 09 December 2009 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your current command to locally export.

Regards
Michel
Re: Export Test database to remote windows location [message #434405 is a reply to message #434395] Wed, 09 December 2009 03:04 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
exp system/pwd@develop file=/home/devora/testDb.dmp log=testDb.log full=y
Re: Export Test database to remote windows location [message #434409 is a reply to message #434405] Wed, 09 December 2009 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the same appliesin your remote server (of course changing the name of the file), assuming you have installed an Oracle client with administrative tools.

Regards
Michel

[Updated on: Wed, 09 December 2009 03:10]

Report message to a moderator

Re: Export Test database to remote windows location [message #434412 is a reply to message #434409] Wed, 09 December 2009 03:30 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
clearly telling you,

my test database is running in Linux server ip 192.182.172.15

other system ip 192.182.172.29(windows) mapped with drobo external hard disk as drive x:

usually i m taking backup in same server as

exp system/pwd@develop file=/home/devora/testDb.dmp log=testDb.log full=y

i would like to export my testdb dump to that ip 192.182.172.29 x: drive

pls help me
Re: Export Test database to remote windows location [message #434413 is a reply to message #434412] Wed, 09 December 2009 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Clearly telling you: on the windows after installing an Oracle client with administrative tools and configuring tnsnames.ora, execute:

exp system/pwd@develop file=x:\testDb.dmp log=testDb.log full=y

Regards
Michel
Re: Export Test database to remote windows location [message #434419 is a reply to message #434413] Wed, 09 December 2009 03:50 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
thanks Mr.Michel

can,t i do it without installing client software on ip 192.182.172.29??

if we want to do that, need to expot and move using FTP correct??
Re: Export Test database to remote windows location [message #434421 is a reply to message #434419] Wed, 09 December 2009 03:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes or install a software that can mount a Windows file system on a Unix box.

http://www.google.com/search?hl=en&source=hp&q=mount+windows+drive+in+linux&aq=2&oq=mount+win&aqi=g10

Regards
Michel
Re: Export Test database to remote windows location [message #434446 is a reply to message #434421] Wed, 09 December 2009 05:17 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Sorry Mr.Michel for keep on asking the same subject

as you said i did export

exp system/pwd@develop file=x:\testdb.dmp log=tesdb.log full=y

i installed client oracle software in ip 192.182.172.29

i configures tnsnames.ora in ip 192.182.172.29 nad i make changes in tnsnames.ora

i could connect the test database whitch is running in linux from the windowns machine

but export file testdb.dmp created in linux machine default location where i exp operation run (/home/devora/x:testdb.dmp)

pls help me, is there anything wrong i did??

or any chnage in file= parameter??

Re: Export Test database to remote windows location [message #434452 is a reply to message #434446] Wed, 09 December 2009 05:39 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
i would like to export my testdb dump to that ip 192.182.172.29 x: drive


1. In linux configure NFS mount point (as 192.182.172.29:X).
2. Create new dictionary to NFS Mount
3. Take backup to new dictionary.

- Babu
Re: Export Test database to remote windows location [message #434481 is a reply to message #434446] Wed, 09 December 2009 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
export file testdb.dmp created in linux machine default location

Did you run the export on Windows machine?

Regards
Michel
Re: Export Test database to remote windows location [message #434503 is a reply to message #434481] Wed, 09 December 2009 07:17 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
before your reply i realize that i did exp in linux machine

when i try to exp from windows machine if i type exp
it saying exp exp command not recognizing

i checked theer is no exp.exe in oracle_home/bin

what to do?
Re: Export Test database to remote windows location [message #434504 is a reply to message #434503] Wed, 09 December 2009 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I said you have to install the administrative tools.
It is an option during the installation of the client.

Regards
Michel
Re: Export Test database to remote windows location [message #434505 is a reply to message #434504] Wed, 09 December 2009 07:35 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Really very thanks to Michel for your prompt reply
it's happy to see the way you are helping people

thanks, i will reinstall client with admin tools
Re: Export Test database to remote windows location [message #434506 is a reply to message #434505] Wed, 09 December 2009 07:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You do not need to reinstall the whole client just reexecute the installer (OUI) and check the option, Oracle will add the missing components.

Regards
Michel
Previous Topic: import a schema
Next Topic: Multiple table insert from single data file
Goto Forum:
  


Current Time: Sat Dec 03 19:56:37 CST 2016

Total time taken to generate the page: 0.16412 seconds