Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export .dmp file
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.
-----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
--
![]() |
![]() |