OraFAQ Forum: Server Utilities » how to export & import database on different network

Home » RDBMS Server » Server Utilities » how to export & import database on different network (Oracel 11.1 Red Hat 4.1.2-41)

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

how to export & import database on different network [message #477287]

Wed, 29 September 2010 23:53

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

Report message to a moderator

Re: how to export & import database on different network [message #477288 is a reply to message #477287]

Thu, 30 September 2010 00:00

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

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

Report message to a moderator

Re: how to export & import database on different network [message #477290 is a reply to message #477289]

Thu, 30 September 2010 00:09

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

Report message to a moderator

Re: how to export & import database on different network [message #477293 is a reply to message #477290]

Thu, 30 September 2010 00:15

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

Report message to a moderator

Re: how to export & import database on different network [message #477297 is a reply to message #477293]

Thu, 30 September 2010 00:30

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

Report message to a moderator

Re: how to export & import database on different network [message #477299 is a reply to message #477287]

Thu, 30 September 2010 00:33

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

OK.
Then please reply how could I use export import those users.

Report message to a moderator

Re: how to export & import database on different network [message #477300 is a reply to message #477299]

Thu, 30 September 2010 00:35

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

exp ... owner=...

Regards
Michel

Report message to a moderator

Re: how to export & import database on different network [message #477362 is a reply to message #477289]

Thu, 30 September 2010 06:22

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

Report message to a moderator

Re: how to export & import database on different network [message #478244 is a reply to message #477362]

Thu, 07 October 2010 07:41

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

Report message to a moderator

Re: how to export & import database on different network [message #478247 is a reply to message #478244]

Thu, 07 October 2010 07:54

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

Report message to a moderator

Re: how to export & import database on different network [message #478267 is a reply to message #478247]

Thu, 07 October 2010 11:05

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Thanks Michel

I will try this.

Report message to a moderator

Previous Topic:	Importing from 9i to 11g - Getting ORA-29339 error because of block size?
Next Topic:	field terminator, record terminator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 21:52:47 CST 2025