472,333 Members | 1,072 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,333 software developers and data experts.

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 71006
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
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
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
8,127 Expert 4TB
are you that dump is taken using IMP file not IMPDP ?
Jul 10 '08 #7

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

Similar topics

by: stic | last post by:
Hi, is there a way to make direct import to PostgreSQL from oracle dmp file ? -- best regards stic
by: Eric Caron | last post by:
Hi I try to import file in a dataset. How I can do this ?
by: kk | last post by:
Hello, I am using the udb 8.1 task scheduler to schedule a load. Is there any way to also schedule an OS command (win32) to delete the file...
by: Jeff Kish | last post by:
Hi. I need to give my customer an sql file that they can run in query analyzer. All the stuff they need to run is in a set of existing files....
by: kaisersose1995 | last post by:
Hi, I've got an import procedure working, using a standard import specification to import a .csv file into a temporary table. The problem i'm...
by: thatipellyrohini | last post by:
Thanks for providing this fecility. Thanks, who giving the answers. i want the code for a txt,xml,xsl import to oracle. here there is a code but...
by: Atran | last post by:
Hello: How I can import a file to my program, and export the file from my program. Example: You see that html pages have images. So I want my...
by: qbytb | last post by:
I have some50 tables in SQL Server to be converted into Oracle. Does anyone know a quicker way (like a tool or utility in Oracle) to do this or i...
by: nandhanvijay | last post by:
hi friends i have a doubt. is it possible to import data from EXCEL if yes how to upload the data from EXCEL to oracle. Am using windows XP the...
by: NigelBrown | last post by:
Hi All, I have the below code but have a couple of problems that I cannot solve, firstly when I select a file the dialog box will promt me to select...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.