Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Export .dmp file

RE: Re[2]: Export .dmp file

From: Leonard, George <>
Date: Thu, 15 Jul 2004 06:57:51 +0200
Message-ID: <>

Hi guys

Well I am from South Africa, but how did I end up in this conversation?

have a nice day.


George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
You Have The Obligation to Inform One Honestly of the risk, And As a Pers= on
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

-----Original Message-----
From: Peter Robson [] Sent: Wednesday, July 14, 2004 2:42 PM
To: Mogens N=F8rgaard
Subject: Re[2]: Export .dmp file


=20Thanks very much for your reply - my apologies for the delay in my
=20own response - an interruption for the annual vacation, don't you

=20Yes, I would indeed be interested in talking to this guy in SA. It
=20seems as though we may have trod similar paths, so input would be =20useful



Tuesday, June 22, 2004, 6:40:30 AM, you wrote:

MN> Peter,

MN> A guy in South Africa I talked to recently has created such a tool.=20 MN> Here's what he wrote to me (because I thought it sounded useful):

MN> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D
MN> I am developing an import tool for oracle (can be extended to other D= Bs=20
MN> as well).

MN> The need for this arose from the shortcomings of imp, the oracle impo= rt=20
MN> tool.

MN> It is still very raw (does not handle raw or LOB data types), but it = has

MN> a select clause for partial table imports, can import into a table ev= en=20
MN> if the structure has changed from the exported table, can import into= =20a=20
MN> different table name than what was exported, and can import partition= ed=20
MN> tables on standard edition.

MN> I have already done 50 million record partial imports with it and the= =20
MN> performance is not half bad!

MN> Anybody who wants to help refine this can mail me, they are more than= =20
MN> welcome.

MN> Do you perhaps know where I can obtain a white paper on the .dmp=20
MN> formats, since I had to figure it out byte for byte so far.
MN> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D

MN> I'll be happy to put you in touch with him offline.

MN> Mogens

MN> Peter Robson wrote:

>> Thanks for that, Lex,


>> Simple reason really - I don't have a test db available right now!
>> Although I agree absolutely that this is the preferred way. I was
>> thinking of something like DataBee, but even that cannot extract
>> metadata if there is data present in the dmp file.
>> =20
>> Plan B however does include creating one...

>> peter
>> =20

>> Monday, June 21, 2004, 12:40:47 PM, you wrote:

>> LdH> Hi Peter,
>> LdH> what's the reason why you don't want to use conventional import?
>> LdH> that tool is precisely meant to offer you all the flexibility you=

>> LdH> to extract only the metadata, the data, with or without grants, .=
>> LdH> just import it in any test database under a DBA account, then
>> LdH> everything you want,
>> LdH> and remove the imported data again ...


>> LdH> Kind regards,
>> LdH> Lex.

>> LdH> ---------------------------------------------
>> LdH> visit my website at
>> LdH> ---------------------------------------------

>> LdH> -----Original Message-----
>> LdH> From:
>> LdH> []On Behalf Of Peter Robson
>> LdH> Sent: Monday, June 21, 2004 12:14
>> LdH> To:
>> LdH> Subject: Export .dmp file

>> LdH> Peeps,

>> LdH> Can anyone advise on a specific problem with one of these?
>> LdH> We have received a large DMP file, created from another (foreign)=

>> LdH> instance by a dba account. We do not want to import this dump fil=
>> LdH> conventionally, but merely to extract the data into some stand-al=
>> LdH> file.

>> LdH> Does anyone know of any tools which will process a .dmp export f=
>> LdH> outwith the Oracle environment?


>> LdH> thanks,

>> LdH> peter
>> LdH> edinburgh
>> LdH> --

>> LdH> -- Binary/unsupported file stripped by Ecartis --
>> LdH> -- Type: text/x-vcard
>> LdH> -- File: Lex de Haan.vcf

>> LdH> ----------------------------------------------------------------
>> LdH> Please see the official ORACLE-L FAQ:
>> LdH> ----------------------------------------------------------------
>> LdH> To unsubscribe send email to:
>> LdH> put 'unsubscribe' in the subject line.
>> LdH> --
>> LdH> Archives are at
>> LdH> FAQ is at
>> LdH> -----------------------------------------------------------------=

MN> ----------------------------------------------------------------
MN> Please see the official ORACLE-L FAQ:
MN> ----------------------------------------------------------------
MN> To unsubscribe send email to:
MN> put 'unsubscribe' in the subject line.
MN> --
MN> Archives are at
MN> FAQ is at
MN> -----------------------------------------------------------------


This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the
BGS. .                  

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

The views expressed in this email are, unless otherwise stated, those of =
the author and not those
of the FirstRand Banking Group or its management.  The information in thi=
s e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone=
=20else is unauthorised.=20
If you are not the intended recipient, any disclosure, copying, distribut=
ion or any action taken or=20
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrit=
y of information and data=20
transmitted electronically and to preserve the confidentiality thereof, n=
o liability or=20
responsibility whatsoever is accepted if information or data is, for what=
ever reason, corrupted=20
or does not reach its intended destination.

=20                              ________________________________
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Wed Jul 14 2004 - 23:54:49 CDT

Original text of this message