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