OraFAQ Forum: Server Utilities » Export Test database to remote windows location

Home » RDBMS Server » Server Utilities » Export Test database to remote windows location (oracle 10.2.0.1.0,Redhat Linux 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Test database to remote windows location [message #434383]

Wed, 09 December 2009 02:00

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434388 is a reply to message #434383]

Wed, 09 December 2009 02:15

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Backup or export?
What is your problem doing an export remotly?

Regards
Michel

Report message to a moderator

Re: Export Test database to remote windows location [message #434390 is a reply to message #434388]

Wed, 09 December 2009 02:24

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.)

Report message to a moderator

Re: Export Test database to remote windows location [message #434391 is a reply to message #434388]

Wed, 09 December 2009 02:28

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434392 is a reply to message #434391]

Wed, 09 December 2009 02:32

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434394 is a reply to message #434392]

Wed, 09 December 2009 02:38

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434395 is a reply to message #434394]

Wed, 09 December 2009 02:44

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post your current command to locally export.

Regards
Michel

Report message to a moderator

Re: Export Test database to remote windows location [message #434405 is a reply to message #434395]

Wed, 09 December 2009 03:04

goracle9
Messages: 136
Registered: December 2006

Senior Member

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434409 is a reply to message #434405]

Wed, 09 December 2009 03:09

Michel Cadot
Messages: 68643
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

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434413 is a reply to message #434412]

Wed, 09 December 2009 03:39

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434419 is a reply to message #434413]

Wed, 09 December 2009 03:50

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??

Report message to a moderator

Re: Export Test database to remote windows location [message #434421 is a reply to message #434419]

Wed, 09 December 2009 03:54

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434446 is a reply to message #434421]

Wed, 09 December 2009 05:17

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??

Report message to a moderator

Re: Export Test database to remote windows location [message #434452 is a reply to message #434446]

Wed, 09 December 2009 05:39

babuknb
Messages: 1736
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434481 is a reply to message #434446]

Wed, 09 December 2009 06:20

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434503 is a reply to message #434481]

Wed, 09 December 2009 07:17

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?

Report message to a moderator

Re: Export Test database to remote windows location [message #434504 is a reply to message #434503]

Wed, 09 December 2009 07:20

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Export Test database to remote windows location [message #434505 is a reply to message #434504]

Wed, 09 December 2009 07:35

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

Report message to a moderator

Re: Export Test database to remote windows location [message #434506 is a reply to message #434505]

Wed, 09 December 2009 07:40

Michel Cadot
Messages: 68643
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

Report message to a moderator

Previous Topic:	import a schema
Next Topic:	Multiple table insert from single data file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:42:15 CDT 2024