OraFAQ Forum: Server Utilities » how to import .dmp into oracle 9i

Home » RDBMS Server » Server Utilities » how to import .dmp into oracle 9i

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

how to import .dmp into oracle 9i [message #134907]

Sun, 28 August 2005 22:28

dai_lo
Messages: 30
Registered: June 2005

Member

Hi,

I can't find any information about importing .dmp into Oracle 9i. All the articles i read are about export.
Could you please provide me detail instruction of importing .dmp file into oracle 9i.

Thank,s

Report message to a moderator

Re: how to import .dmp into oracle 9i [message #134918 is a reply to message #134907]

Mon, 29 August 2005 00:35

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Always better to read the documentation.

when i google i got lots of results.

http://www.google.co.in/search?hl=en&q=import+.dmp+file+in+Oracle+9i&meta=

And one specific

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci905149,00.html?Exclusive=True

Its really easy to google things first.

regards,
tarun

Report message to a moderator

Re: how to import .dmp into oracle 9i [message #135095 is a reply to message #134918]

Mon, 29 August 2005 21:05

dai_lo
Messages: 30
Registered: June 2005

Member

the article you sent me didn't mention where i should run this command
imp userid=system file=user_a.dmp log=imp.log fromuser=a touser=b

if the .dmp file is located in c:\
should i have file=c:\user_a.dmp ?
did I need to manually create a imp.log file?
how can I know the fromuser name?

thanks

Report message to a moderator

Re: how to import .dmp into oracle 9i [message #135157 is a reply to message #134918]

Tue, 30 August 2005 03:31

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
say you have a database db1 installed on one pc and the other database db2 installed on another pc.
Now say you have a user "scott" in db1 and you want to export this user from db1 to db2.
The first step is to create a new user in db2 say xyz.

Now export the user scott from db1 by this method.
Open the command prompt and enter in c:
Now issue this command from the command prompt

c:\>exp system/manager file=scott.dmp owner=scott

where system/manager is the administrator in your db1.

Now after the export completes, you can see the file scott.dmp in your c:

Now copy this file to other computer's c: where you have your db2 installed.

I assume that you have already created the user named xyz (or whatever you want) on your new machine.

Now Open the command prompt from this machine and issue the following command:

c:\>imp system/manager file=scott.dmp fromuser=scott touser=xyz

here system/manager is the administrator on your db2. fromuser is the user for which you exported the data. touser is the user where you'r going to import the data of the previously exported user.

After the import completes, you'r done. Your old user is exported to the new user.

I hope this should be clear to you now.

Regards.

Report message to a moderator

Re: how to import .dmp into oracle 9i [message #135294 is a reply to message #135157]

Tue, 30 August 2005 16:19

dai_lo
Messages: 30
Registered: June 2005

Member

is there any way i can find out the name of owner (fromuser) in the .dmp file?

Thanks

Report message to a moderator

Re: how to import .dmp into oracle 9i [message #135304 is a reply to message #135294]

Tue, 30 August 2005 18:53

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

Senior Member
Account Moderator

You are supposed know from whom you are about to import.
Ofcourse yes. You can get all the usernames from the dmp file.
But it would not decide for you!.
try this.

imp dba/password full=y show=y log=somefile.log file=somefile.dmp

THe import is not actually done.
Instead all the DDL is dumped into this file somefile.log.
Check the file. You get the information you need.

Report message to a moderator

Previous Topic:	importing packages...!
Next Topic:	load XML file in oracle table using SQL*LOADER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 06:45:38 CDT 2024