Re: converting .dmp to .csv

extract data from offline dmpfile is very tricky. There is a dul util that comes with oracle proffesional services, which will cost big $$ and very slow.

better import dump file to oracle that doesn't have to be the origin of export.
then extract data into flat files using pl sql or dts. If tables are large and duration of extract process is critical, then you could use fastreader from wisdomforce www.wisdomforce.com fastreader will create a loader to sqlserver automatically as well for convinience

JMNUSS wrote:
> I am a SQL Server DBA...I'll wait for the laughing to stop :)
>
> Is anyone aware of a utility that we can use\purchase that can be used
> to convert an Oracle .dmp file to some other usable format for SQL
> Server.... like .csv maybe.
>
> TIA Jordan
Received on Wed Mar 15 2006 - 10:56:44 CST