Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

-Martin

3 replies

by mohdfarid914

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.

by info

Thanks for your suggestion.

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

Thanks again.

This discussion is closed to new replies.