Re[2]: Export .dmp file

From: Peter Robson <pgro_at_bgs.ac.uk>
Date: Mon, 21 Jun 2004 13:32:54 +0100
Message-ID: <756368026.20040621133254@bgs.ac.uk>

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...

peter

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 http://www.naturaljoin.nl

LdH> ---------------------------------------------


LdH> -----Original Message-----
LdH> From: oracle-l-bounce_at_freelists.org
LdH> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Robson
LdH> Sent: Monday, June 21, 2004 12:14

LdH> To: oracle-l_at_freelists.org
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: http://www.orafaq.com
LdH> ----------------------------------------------------------------
LdH> To unsubscribe send email to:  oracle-l-request_at_freelists.org
LdH> put 'unsubscribe' in the subject line.
LdH> --
LdH> Archives are at http://www.freelists.org/archives/oracle-l/

LdH> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

LdH> -----------------------------------------------------------------

mailto:pgro_at_bgs.ac.uk

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. .                            http://www.bgs.ac.uk
*********************************************************************



----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jun 21 2004 - 07:29:53 CDT