how to import a .dmp file in oracle ?

[parapatil]

I have a .dmp file. This file was exported by someone else. The file was exported as the back up of a database. I know only the name of the database. I dont know the user account who actually exported the file. I want to restore the database at my end.
- The .dmp I have, was exported through oracle 9i.
- Can I import it into Oracle 10g ?

Please help to import this file to use the database. The only thing is i don't know the user account who exported this file ?

[amitpatel66]

You can IMPORT a file in to database using folloeing IMPORT command:

To import full dmp file:

1. imp scott/tiger file=emp.dmp log=imp.log full=yes

To import dept table alone:

2. imp scott/tiger file=emp.dmp log=imp.log fromuser=scott touser=scott tables=dept

scott/tiger - user_name/password

FROMUSER and TOUSER clause are optional. But in case if used, then create a user in the destination database that is mentioned in TOUSER clause then try importing the dmp file.

[tuffytom]

i am not able to import the .dmp file in oracle

[amitpatel66]

i am not able to import the .dmp file in oracle

What is the problem that you are facing??

[debasisdas]

i am not able to import the .dmp file in oracle

Kindly post the exact error message with error number for more details on the topic.

[dreampeppers99]

Kindly post the exact error message with error number for more details on the topic.

I have file.dmp but when I try to imp gives erros... (I omit the userfrom clausure...) and I think that the user (when exp) put the touser, so now how can I discovery the user from this file.dmp?


thanks in advance

[debasisdas]

are you that dump is taken using IMP file not IMPDP ?