Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export .dmp file

RE: Export .dmp file

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 21 Jun 2004 13:40:47 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNGELFCEAA.lex.de.haan@naturaljoin.nl>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Robson Sent: Monday, June 21, 2004 12:14
To: oracle-l_at_freelists.org
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
--


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 - 06:37:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US