Re: Tool For Extracting Data From DMP file

From: todderamaa <todd_at_compass-cama.com>
Date: Wed, 26 Feb 2003 00:22:40 GMT
Message-ID: <3E5C08D7.4030800@compass-cama.com>

I actually found someone who has a tool. It works quite well. I downloaded a trial version which stripped out the Create Table Statements as well as exported the data (tab delimited text).

This works great but there is a price for the production version. I was just wondering if there is a less expensive way of stripping the data before I pay for this tool.

Todd

Michael Mauch wrote:
> DA Morgan <damorgan_at_exesolutions.com> wrote:
>

>>todderamaa wrote:

>
>

>>>I am wondering if there is a tool that allows someone to extract the
>>>data from a DMP file.  Something other than Oracle itself.
>>>
>>>It would be great if it could extract the data as INSERT Statements.
>>

>

>>By DMP file are you referring specifically to a file created by Oracle
>>EXPort?

>
>
> I think so. "exp" is rather fast. Pity that it doesn't have a
> PLAINTEXT=YES switch.
>
>

>>If so, you might want to open one up with a text editor and look inside.

>
>
> Apart from a bit binary "crap" and insert statements with bind variables
> and binary data, it looks rather nice here - but that might be platform
> and Oracle version dependant, of course.
>
> There's a guy who started to write a tool to read export files, see:
>
> <http://www.orafaq.net/archive/comp.databases.oracle.server/2002/02/10/134700.htm>
> <http://groups.google.com/groups?lr=&ie=UTF-8&threadm=01HW.B3301AA20000A00D124FA42C%40mail.wxs.nl&rnum=6&prev=/groups%3Fhl%3Dde%26lr%3D%26ie%3DISO-8859-1%26scoring%3Dd%26q%3Dexpdat.dmp%2Btext%26btnG%3DGoogle-Suche>
>
> Regards...
> Michael
Received on Tue Feb 25 2003 - 18:22:40 CST