RE: Export .dmp file

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 21 Jun 2004 13:40:47 +0200

Hi Peter,
what's the reason why you don't want to use conventional import?
that tool is precisely meant to offer you all the flexibility you need
to extract only the metadata, the data, with or without grants, ...

just import it in any test database under a DBA account, then retrieve
everything you want,
and remove the imported data again ...

Kind regards,
Lex.

---------------------------------------------
visit my website at http://www.naturaljoin.nl
---------------------------------------------


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Peter Robson
Sent: Monday, June 21, 2004 12:14
To: oracle-l@xxxxxxxxxxxxx
Subject: Export .dmp file


Peeps,

Can anyone advise on a specific problem with one of these?

We have received a large DMP file, created from another (foreign)
instance by a dba account. We do not want to import this dump file
conventionally, but merely to extract the data into some stand-alone
file.

Does anyone  know of any tools which will process a .dmp export file
outwith the Oracle environment?

thanks,

peter
edinburgh
--


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


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