Extract data from dmp-file without Oracle

350765 pts.
Tags:
DMP Importing
Oracle
I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...?

Software/Hardware used:
Oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello have you figured out a way to extract large oracle dump file to csv? Please let me know my email is mntelmen@gmail.com

——————–

It is best to import the dmp file into the database and use pl / sql to create CSV file. In this way that u may sure the CSV file contains all the data in the dmp file. Or download and use OraDump Export Kit for that purpose

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mntelmen
    I i have tried to import my dmp file to oracle but i get an error IMP-00010: not a valid export file, header failed verification. Also i have tried the OraDump program but i had no luck with it, because all the data in the dump file has win1251 Cyrillic characters in it. OraDump exports just empty boxes. i don't think the program supports the character set. Also tried extract demo utility it works but i can't find the full version of the software. The website is no longer available. Please let me know if you have any other suggestions.
    25 pointsBadges:
    report
  • ColinM
    If you need the meta-data, that is, the object definitions, the DDL wizard tool is good. It's free from http://www.ddlwizard.com/ - this will work with a full .DMP or a
    rows=no
    file.
    10 pointsBadges:
    report
  • mallik143
    thank u for ur suggestion
    it helps me a lot
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following