aspose file tools*
The moose likes Oracle/OAS and the fly likes how to open an oracle DMP file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "how to open an oracle DMP file" Watch "how to open an oracle DMP file" New topic
Author

how to open an oracle DMP file

Haytham Douaihy
Greenhorn

Joined: May 10, 2012
Posts: 14

I have an Oracle DMP file, without knowing its related database tables or other any info on when/who has created it. So, anybody have an idea to help me open it or extract its related DDL?
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

This is most probably a dump file created by either the EXP, or EXPDP utility. You can use IMP (if it was EXP) or IMPDP (if it was EXPDP) to extract DDL from these files.

I don't know how to distinguish the two formats, my advice would be to try to access the files using IMPDP first, and it that fails, using IMP. All of these utilities are described in the documentation. It seems that in case of IMPDP, you can use the SQLFILE parameter to dump the DDL of contained DB objects. The IMP has a similar SHOW parameter.

There are usually log files created during import/export, if you had the import log file, you'd see what was exported and when. Perhaps you could obtain the log from the same source you obtained the DMP from?
Haytham Douaihy
Greenhorn

Joined: May 10, 2012
Posts: 14

hi Martin,

sorry for late reply. this is an old DB dmp file. i think i will not be able to recover data from it as i know neither the user/pass used when exporting nor the log files.
all what i know is most of its tables ddl, IMP utility was not the key for recovering content.

i think it's fair not being able to recover

thanks for help
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

Oracle's DMP files are not password protected. At least since Oracle 9i. I don't have experience with prior versions, but I believe these should be fairly backwards compatible.

Did you try to view the contents of the file in a text/hex viewer? An old DMP file I've found on my drive contains the text EXPORT:V10.02.01 right at the beginning of the file (after about three unreadable characters that probably form some part of a header).

It is of course possible that it is not proper Oracle dump file after all. Especially if the IMP/IMPDP tools refused to process the file.
Haytham Douaihy
Greenhorn

Joined: May 10, 2012
Posts: 14

i opened it in notepad++. it is about 800,000 lines. in the first lines, there is some characters that we can understand. they are below, else nothing is readable

VOL1 1 7
HDR1MDB_S120927413A0E
Sybase 13A0E
HDR2F
0204803 OPTI_S12 00000000002000012803 0000008
Adaptive Server Enterprise/12.5.4/EBF 16143 ESD#9/P/x86_64/Enterprise Linux/ase1254/2143/64-bit/OPT/n

Adaptive Server Enterprise/12.5.4/EBF 16143 ESD#9/P/x86_64/Enterprise Linux/ase1254/2143/64-bit/OPT/n


it's clear it is a sybase and not oracle... that's another problem!


 
jQuery in Action, 2nd edition
 
subject: how to open an oracle DMP file