Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re[2]: Export .dmp file

From: Peter Robson <>
Date: Mon, 21 Jun 2004 13:32:54 +0100
Message-ID: <>

 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.  

 Plan B however does include creating one...


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 need
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 retrieve
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 file
LdH> conventionally, but merely to extract the data into some stand-alone
LdH> file.

LdH> Does anyone know of any tools which will process a .dmp export file 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> -----------------------------------------------------------------


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
Received on Mon Jun 21 2004 - 07:29:53 CDT

Original text of this message