Re: Tool For Extracting Data From DMP file

From: Michael Mauch <michael.mauch_at_gmx.de>
Date: Tue, 25 Feb 2003 23:50:35 +0100
Message-ID: <ri8tixc3d.ln2@elmicha.333200002251-0001.dialin.t-online.de>

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 - 16:50:35 CST