Converting an Oracle DMP file to CSV or a MSQL Server Table

I have a customer who is sending me Oracle dump files which I want to convert to CSV or MSQL Server tables.  I have used a product called "Intelligent Converter" but it is painfully slow taking 5-6 hours to convert to a Table and 24+ hours to convert to a CSV.  The files are not that big 500 mb, Compressed and 1.5 GB non Compressed and we really only need a small fraction of the columns.

Currently we have an elaborate process which takes the file into a server running oracle off our main network and then exports it as csv to upload to another network and then to an SQL database.  We would like to be able to do this in one step and either upload directly the csv to the Table or create/append an SQL Table directly.
aovikingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Oracle DMP files are created with either classic exp or new datapump expdp.

They are proprietary binary file formats.

The only 'approved' tools to access them is the imp or impdp tools that import the data into an existing database.

The only way to possibly speed it up is create an Oracle database, import the data and create your CSV or use something like SSIS.
0
aovikingAuthor Commented:
I am already doing essentially that.. I think they can be converted because of the aforementioned tool but it is really slow... There must be a better faster way.
0
slightwv (䄆 Netminder) Commented:
The only 'valid' way to read an Oracle DMP file is with Oracle import utilities.

I've never seen any tool or talk about the physical layout of a DMP file.  Then again, I've never really looked.

Considering the tool you mentioned, it looks like someone has taken the time to figure out the format of the file and written their own tool but I'm pretty sure it isn't supported by Oracle.

Feel free to try to figure out the format and write your own but I feel this would be a losing proposition.

I think it would be much more productive to work directly with the people providing the DMP file and work on an alternative file format.  Oracle to CSV or XML is straight forward and easy to do.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

aovikingAuthor Commented:
Thanks. Here is what we have been using- www.intelligent-converters.com
0
PortletPaulfreelancerCommented:
option A. ask the customer to send you something better suited to your need.

option B. get a free version of Oracle up & running and import the .dmp into that, then export from (or read from) this

option C. discuss your issues with the vendor of that utility
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Geert GOracle dbaCommented:
from the source you got .dmp files

why not ask the source to export the files as csv ?

what is the point in that complete workaround process ?
0
aovikingAuthor Commented:
Follow up to last 2 comments.  Of course we have asked the customer to give us non .dmp files.  We are currently importing and exporting out of oracle to make the conversion to MS-SQL and we have contacted the vendor directly.  We did these things before I posted the question.

The point of my post was to see if anyone had experience with any tool which had better performance than what we are getting with the intelligent converter.  If we have to keep using the Oracle import/export routine we will, but it would be nice to get around that step.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.