AboutElliot Mak Expertise I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, and SQL.
Experience I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
Expert: Elliot Mak Date: 7/5/2008 Subject: import data from .dmp file
Question I have a vdata.dmp file created in oracle 9.0.1.1.1. I do not know any user,password and any pervilization of that database. Now how can I recover data from a .dmp file. plz send the solution.
Answer Good day Munna
Here is what I will do in this situation
1. Write the DDL from DMP file
2. Examine the DDL, create the users, and the tablespaces required for the import
3. import the DMP file using schema list
After the import, you will need to go thru all the users to change the password if needed.
Hope this helps, if you shall have any questions, please don't hesitate to contact me and I am happy to assist you.
