Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2016
    Posts
    7

    Unanswered: How to read my .dmp oracle file databases

    Hi,

    I have no oracle software installed

    I want just to read .dmp files for oracle databases without using an oracle software

    My .dmp files are enregistred in my machine and not in on a server

    Thks a lot

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What does it mean "you want to READ"? Using a text editor? If so, what's stopping you from doing it?

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    The only tools that can read a .dmp files are the Oracle tools (either imp or impdp depending on how the dump was taken).
    In any case you need a running Oracle database in order to "read" them.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  4. #4
    Join Date
    Mar 2016
    Posts
    7
    Hi guys,

    Is it possible to import these .dmp files from another Dabases (mysql, pgsql,...)????

    If so, how can I process???


    Thank you

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by MarwenGafsi View Post
    Is it possible to import these .dmp files from another Dabases (mysql, pgsql,...)????

    If so, how can I process???
    Again: The only tools that can read a .dmp files are the Oracle tools.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The process that I'd use would be:

    1. Install Oracle (same or later version than made the DMP file) on your destination machine.
    2. ETL the data from the Oracle database to a PostgreSQL database.
    3. Remove Oracle installation when done.

    If you had infinite time and resources, you might be able to write a DMP extractor to transfer to another database engine, but so far I don't know of anyone who has found a practical and profitable way to do this.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •