[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2078
  • Last Modified:

.dmp File

I am working on a vendor file clean-up and I received a .dmp file which I need to open and import into either Access or Excel.  I am used to getting .csv files which I have no problems importing into either Access, Excel, or text editors; however this .dmp file doesn't open with any of the applications I am used to using.


I was told I can 'create an "oracle test database" and then link my Access database to this "oracle test database" via ODBC.'  However I am not proficient in Oracle nor do I know how to create an "oracle test database" nor the right application to do this with.  

Can someone help or provide me with step by step instructions on what or how to open this .dmp file?

Thanks!
0
gemontes
Asked:
gemontes
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
mrjoltcolaCommented:
Assuming the file is an Oracle .dmp (export) file, you cannot open it with Access or Excel. It is an Oracle format.

You can either ask the originator to send you a CSV file, or install Oracle and import the file into an empty instance.

I recommend downloading Oracle from Oracle's website, running the installer and choosing the defaults to create the sample database.

Then use "imp" to import the file.

The problem here is we have no information whether the .dmp file is for a single database schema or a full export (whole database). How you import it depends on that. Ask the person who sent you what version of Oracle and also how he did the export, so you know how to import it.

Example:
  To import from a full export file an old schema named fred, into a new schema user named barney...

With imp:
  set ORACLE_SID=ORA1
  imp system/admin file=export.dmp fromuser=fred touser=barney

0
 
gemontesAuthor Commented:
Thanks for your comment; we are trying to get the file in a CSV formatt the originator did give me these instructions:
 
'...create a blank database using the Oracle Database Configuration Wizard.  The following command will import the dump file we provided into the database:
 
imp openffs/<password>@<SID> file=mf_vend_doc_jn.dmp commit=y ignore=y buffer=20000000 log=import.log fromuser=openffs touser=openffs'
 
I also don't know what Oracle application I need... Can you please specify as to what exact aplication from oracle I need?
 
Thanks
0
 
FayyazCommented:
once you installed oracle software and database properly you don't need any other tool to import the said dump file. go to OS command prompt and type the above command supplied by your vendor and it will work.
I think before using the above command you have to create a openffs user in new database and setup the tnsnames.ora also.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
gemontesAuthor Commented:
Experts,
I'm not well versed in Oracle, could you please specify which exact download of Oracle and said application I need to install please.  This would be most helpful.
 
Thanks...
 
 
0
 
FayyazCommented:
Ask the originator of dmp file, which version of oracle is required for you to install. then go to oracle.com site and download that version. run setup.exe and it will guide you accordingly.
0
 
mrjoltcolaCommented:
That is a user (schema) import.

How large is the dmp file. It might require creating a tablespace for the user if it is large. The default USERS tablespace may not be large enough.

So after installing Oracle (consider getting Express edition, it is free) then after setup, create an openffs tablespace, create the schema user, like so:

sqlplus  / as sysdba
SQL> create tablespace openffs datafile 'C:\oracle\oradata\ORA1\openffs.dbf' size 1g;
SQL> create user openffs identified by <password> default tablespace openffs;
SQL> grant resource, create view, create procedure, connect to openffs;
SQL> exit

Then from OS prompt do import:

imp openffs/<password>@<SID> file=mf_vend_doc_jn.dmp commit=y ignore=y buffer=20000000 log=import.log fromuser=openffs touser=openffs'

0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
the  originator can only tell u about the version of the oracle software to be installed, so please ask your originator and download the same from oracle website and install it.

follow the procedure given by mrjoltcola:.....
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now