Re[2]: Export .dmp file
- From: Peter Robson <pgro@xxxxxxxxx>
- To: Lex de Haan <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 13:32:54 +0100
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@xxxxxxxxxxxxx
LdH> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Peter Robson
LdH> Sent: Monday, June 21, 2004 12:14
LdH> To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
LdH> put 'unsubscribe' in the subject line.
LdH> --
LdH> Archives are at //www.freelists.org/archives/oracle-l/
LdH> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
LdH> -----------------------------------------------------------------
--
mailto:pgro@xxxxxxxxx
*********************************************************************
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
