• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

how to open an oracle DMP file

 
Greenhorn
Posts: 14
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 14
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 Vashko
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 14
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!


 
reply
    Bookmark Topic Watch Topic
  • New Topic