Home » RDBMS Server » Server Utilities » how to export & import database on different network (Oracel 11.1 Red Hat 4.1.2-41)
how to export & import database on different network [message #477287] Wed, 29 September 2010 23:53 Go to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
hi

I want to create two or three sachems on my production server which should be the same copy of my another second production server. And I access this second server through VPN connection on toad9.0.1. And I access my production server through VNC viewer and database through toad.
So please tell me how cloud I create schema on my first prod. server from second server.

Regards//Neha
Re: how to export & import database on different network [message #477288 is a reply to message #477287] Thu, 30 September 2010 00:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What are sachems? Ah! schemas...

Question not clear, the core could be:
exp ... owner=...
ftp ...
imp ... full=y

Regards
Michel

[Updated on: Thu, 30 September 2010 00:00]

Report message to a moderator

Re: how to export & import database on different network [message #477289 is a reply to message #477288] Thu, 30 September 2010 00:04 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
If I use export utility then it will save dmp file on server which is on another location then how could I import this dmp file on production server which is also on another location.

Regards//Neha
Re: how to export & import database on different network [message #477290 is a reply to message #477289] Thu, 30 September 2010 00:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
FTP or USB key or what you want to move the file if you can't remotely access it.

Regards
Michel
Re: how to export & import database on different network [message #477293 is a reply to message #477290] Thu, 30 September 2010 00:15 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
I access these databases through TOAD but when I export any user it creates dmp file and save on server not on my system then Is there any solution to save this dmp on my system so that I can use this dmp for another server while importing. Or is there any procedure or tool or anything for creating same schema on different server?

Regards//Neha
Re: how to export & import database on different network [message #477297 is a reply to message #477293] Thu, 30 September 2010 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Throw away TOAD and start to properly work.

Quote:
Or is there any procedure

Is this not what I posted.
There are many scripts on the web as this question has been many asked many times, you just have to think to leave TOAD.

Regards
Michel
Re: how to export & import database on different network [message #477299 is a reply to message #477287] Thu, 30 September 2010 00:33 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
OK.
Then please reply how could I use export import those users.
Re: how to export & import database on different network [message #477300 is a reply to message #477299] Thu, 30 September 2010 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
exp ... owner=...

Regards
Michel
Re: how to export & import database on different network [message #477362 is a reply to message #477289] Thu, 30 September 2010 06:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>If I use export utility then it will save dmp file on server
That is true with expdp. Not with exp tool that you are trying to use.
Exp dump files are created wherever you call from.

Since you can connect through Toad, there must be tns entry involved. Assuming all are same versions, this should work.
Just use command line exp

exp user/password@source ..
imp user/password@target ..
Re: how to export & import database on different network [message #478244 is a reply to message #477362] Thu, 07 October 2010 07:41 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Hi all

I use export/import.And it works ok
But the problem is I am importing whole db schema not data but when it imports is it necessary that schema is already created in db where I am importing.
I export db without data from X server and import into Y DB on another server.But when importing error shows user does not exist.
It is really tough to create 50 or 60 users for me.
Please tell me how to do this task?

Regards//
Neha
Re: how to export & import database on different network [message #478247 is a reply to message #478244] Thu, 07 October 2010 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
It is really tough to create 50 or 60 users for me.

Use DBMS_METADATA to extract the CREATE USER statements from your source database and execute the result into the target one, nothing tough.

Regards
Michel
Re: how to export & import database on different network [message #478267 is a reply to message #478247] Thu, 07 October 2010 11:05 Go to previous message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Thanks Michel

I will try this.
Previous Topic: Importing from 9i to 11g - Getting ORA-29339 error because of block size?
Next Topic: field terminator, record terminator
Goto Forum:
  


Current Time: Mon Dec 23 09:46:45 CST 2024