OraFAQ Forum: Server Utilities » import full database using import dump

Home » RDBMS Server » Server Utilities » import full database using import dump (Oracle,10.2.3,solaris)

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

import full database using import dump [message #300784]

Mon, 18 February 2008 02:27

sheldon1982
Messages: 59
Registered: February 2008
Location: india

Member

HI,
i want to take a full import of a database which are on the same node.i am using datapump utility. i already have export dump.
i want to import that file on another which is on same node.

impdp hr/hr DUMPFILE=dpump_dir1:expfull.dmp FULL=y
LOGFILE=dpump_dir2:full_imp.log
is this correct.
i want to know that both db are on the same in this case the upper command will work.
please explain me???\

Thanks ,
Sheldon

Report message to a moderator

Re: import full database using import dump [message #300872 is a reply to message #300784]

Mon, 18 February 2008 07:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

make use of tns entries.
Something like
impdp hr/hr@other_database_you_want.
Or
set your ORACLE_SID to be other_database_you_want

Report message to a moderator

Re: import full database using import dump [message #300892 is a reply to message #300872]

Mon, 18 February 2008 08:58

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

Hi Mahesh,
you mean to say this way
export ORACLE_SID=sid of database to which i want to import
then the impdp command.

thanks,
Daniesh

Report message to a moderator

Re: import full database using import dump [message #300894 is a reply to message #300892]

Mon, 18 February 2008 09:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can re-phrase the same in several other languages also.

Report message to a moderator

Previous Topic:	problem with exp command
Next Topic:	Can't recreate 9i to 10g with EXP/IMP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:55:55 CST 2024