OraFAQ Forum: Server Utilities » Exm/Imp Full Database

Home » RDBMS Server » Server Utilities » Exm/Imp Full Database

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

Exm/Imp Full Database [message #252912]

Fri, 20 July 2007 10:53

allahmorad
Messages: 18
Registered: June 2006

Junior Member

Hello
I have a 10g database with 12 tablespace , 40 user , more than 2000 table , i want copy database from server 1 to server2
with exp/imp . please help me how to this step bye step

thank you
allahmorad

Report message to a moderator

Re: Exm/Imp Full Database [message #252913 is a reply to message #252912]

Fri, 20 July 2007 10:54

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Use datapump for better performance.
step1:Take export on your server A
step2:create database ,same tablespaces,users on server B.
step3:scp your export dmp to server B.
ster4:import your dump to server B.

[Updated on: Fri, 20 July 2007 10:55]

Report message to a moderator

Re: Exm/Imp Full Database [message #252922 is a reply to message #252913]

Fri, 20 July 2007 11:14

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

Senior Member
Account Moderator

You don't need to create tablespaces and users if you take a full export.
The import will recreate them.

Regards
Michel

Report message to a moderator

Re: Exm/Imp Full Database [message #253186 is a reply to message #252912]

Mon, 23 July 2007 01:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

If you want to shift complete database then best approach is you should install oracle software on server B and through RMAN, COLD BACKUP shift Server A database to Server B.

or if you want to just shift application schema then you go with exp/imp tools.

Regards
Taj

Report message to a moderator

Previous Topic:	Returning to this window.
Next Topic:	data import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:34:29 CDT 2024