Home » RDBMS Server » Server Utilities » Import whole database to another database.. is it possible? (AIX, Oracle 11.2.0.2)
Import whole database to another database.. is it possible? [message #534621] Wed, 07 December 2011 20:23 Go to next message
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.
Re: Import whole database to another database.. is it possible? [message #534622 is a reply to message #534621] Wed, 07 December 2011 20:51 Go to previous messageGo to next message
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/

Re: Import whole database to another database.. is it possible? [message #534626 is a reply to message #534622] Wed, 07 December 2011 23:15 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I cannot use datapump. The export is already there which has used the original export method.
Re: Import whole database to another database.. is it possible? [message #534627 is a reply to message #534626] Wed, 07 December 2011 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
imp help=yes

Regards
Michel
Re: Import whole database to another database.. is it possible? [message #535118 is a reply to message #534626] Mon, 12 December 2011 04:31 Go to previous message
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:
  


Current Time: Thu Mar 28 12:13:09 CDT 2024