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.