469,315 Members | 2,141 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

how to import a .dmp file in oracle ?

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 ?
Sep 2 '07 #1
6 70798
amitpatel66
2,367 Expert 2GB
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.
Sep 2 '07 #2
i am not able to import the .dmp file in oracle
Oct 19 '07 #3
amitpatel66
2,367 Expert 2GB
i am not able to import the .dmp file in oracle
What is the problem that you are facing??
Oct 19 '07 #4
debasisdas
8,127 Expert 4TB
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.
Oct 19 '07 #5
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
Jul 9 '08 #6
debasisdas
8,127 Expert 4TB
are you that dump is taken using IMP file not IMPDP ?
Jul 10 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by stic | last post: by
2 posts views Thread by Eric Caron | last post: by
5 posts views Thread by kk | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.