Re[2]: Export .dmp file
- From: Peter Robson <pgro@xxxxxxxxx>
- To: Mogens Nørgaard <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Jul 2004 13:41:53 +0100
Mogens,
Thanks very much for your reply - my apologies for the delay in my
own response - an interruption for the annual vacation, don't you
know...!
Yes, I would indeed be interested in talking to this guy in SA. It
seems as though we may have trod similar paths, so input would be
useful
cheers,
peter
edinburgh
........
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.
MN> Here's what he wrote to me (because I thought it sounded useful):
MN> ===================================================
MN> I am developing an import tool for oracle (can be extended to other DBs
MN> as well).
MN> The need for this arose from the shortcomings of imp, the oracle import
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 even
MN> if the structure has changed from the exported table, can import into a
MN> different table name than what was exported, and can import partitioned
MN> tables on standard edition.
MN> I have already done 50 million record partial imports with it and the
MN> performance is not half bad!
MN> Anybody who wants to help refine this can mail me, they are more than
MN> welcome.
MN> Do you perhaps know where I can obtain a white paper on the .dmp
MN> formats, since I had to figure it out byte for byte so far.
MN> =====================================================
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.
>>
>> 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> -----------------------------------------------------------------
>>
>>
>>
MN> ----------------------------------------------------------------
MN> Please see the official ORACLE-L FAQ: http://www.orafaq.com
MN> ----------------------------------------------------------------
MN> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
MN> put 'unsubscribe' in the subject line.
MN> --
MN> Archives are at //www.freelists.org/archives/oracle-l/
MN> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
MN> -----------------------------------------------------------------
--
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:
