OraFAQ Forum: Server Utilities » Import whole database to another database.. is it possible?

Home » RDBMS Server » Server Utilities » Import whole database to another database.. is it possible? (AIX, Oracle 11.2.0.2)

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

Import whole database to another database.. is it possible? [message #534621]

Wed, 07 December 2011 20:23

lg123
Messages: 225
Registered: August 2008

Senior Member

Is it possible to import one whole database in to another whole database? Please let me know.

Report message to a moderator

Re: Import whole database to another database.. is it possible? [message #534622 is a reply to message #534621]

Wed, 07 December 2011 20:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is it possible to import one whole database in to another whole database?
yes, but first a DB must be exported
expdp help=yes
impdp help=yes

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Import whole database to another database.. is it possible? [message #534626 is a reply to message #534622]

Wed, 07 December 2011 23:15

lg123
Messages: 225
Registered: August 2008

Senior Member

I cannot use datapump. The export is already there which has used the original export method.

Report message to a moderator

Re: Import whole database to another database.. is it possible? [message #534627 is a reply to message #534626]

Wed, 07 December 2011 23:20

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

Senior Member
Account Moderator

imp help=yes

Regards
Michel

Report message to a moderator

Re: Import whole database to another database.. is it possible? [message #535118 is a reply to message #534626]

Mon, 12 December 2011 04:31

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

I cannot use datapump. The export is already there which has used the original export method.

If you are using the following command to export a full database "mydb".

exp userid="'/ as sysdba@mydb'" file=MAXIMO.dmp log=MAXIMO_exp.log full=y rows=y direct=y

Then,
you can use the following to import the same into orcl database

imp userid="'/ as sysdba@orcl'" file=MAXIMO.dmp log=MAXIMO_imp.log

[Updated on: Tue, 13 December 2011 00:06]

Report message to a moderator

Previous Topic:	Directories in data pump
Next Topic:	problem with sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 06:41:00 CST 2024