We have asked our clients for certain data in a csv file format and we just got a .dmp file. I have been trying to open it using MySQL as if it were .dump but it doesn't work.

I have seen other posts where they restore .dmp files with Oracle but I have 0 experience with Oracle (and very little with databases overall). Is there any alternative to get the contents of the .dmp file into a csv format?

  • 1
    Unlikely. If that is a file generated by either the classic or Data Pump version of the Oracle export utility, it's a proprietary binary file format. There may be third party tools that could read the .dmp file and produce a .csv file. But then you're evaluating tools, buying a tool, learning the tool, etc. On a one-off basis, it may be just as easy to grab the express edition of Oracle, restore it, and then generate whatever you want. Or to ask the customer to generate an actual CSV file. – Justin Cave Sep 9 '15 at 15:45
  • Thanks @JustinCave, so then the only alternative would be to install Oracle and try to restore it myself, right? – user3507584 Sep 9 '15 at 15:52
  • 2
    Your basic options, assuming this is actually a file generated by the Oracle export utility (classic or Data Pump) would be to 1) find a third party tool, 2) install Oracle and import it there, or 3) ask the customer to give you a CSV file. – Justin Cave Sep 9 '15 at 15:57
  • @Justin cave, csv file option is better. Because again it required to him import the. Dmp file through data pump into oracle. – Md Haidar Ali Khan Sep 9 '15 at 19:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.