How to extract data from Oracle dmp-file without Oracle ?

By info ·
I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get a TXT or CSV output.

NXTract could not manage this because of the size (buffer overflow error).

Is there any other tool out there that can help me...?
Thanks in advance.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Tool/process to dump Oracle data into a text file.

by mohdfarid914 In reply to How to extract data from ...

I have never tried to convert or export data from .dmp file into a text file and probably never will.

Personally, I prefer methods that allows me to verify a process. In this case, you should look into process/method that allows you to verify that the data being exported is correct and complete.

With the availability of Oracle Express Edition (XE) for download, you should try to load the data from .dmp file into an Oracle database before migrating the selected data into text files. Then, you can use the Data Unload utilities to unload the data into a text file.

I am sorry if this is now the answer you expected. But, it is my personal recommendation that you consider this method instead.

Collapse -


by info In reply to Tool/process to dump Orac ...

Thanks for your suggestion.

At the end, I used another database in another format (dbase), that I could access easily.

Thanks again.

Related Discussions

Related Forums