Re: How to retrieve function from .dmp file

In article <922bgf$54o$1_at_nnrp1.deja.com>,   Inna <mednyk_at_my-deja.com> wrote:
>
>
> Happy holidays. Even in these days I have to ask you about help.
>
> I made a backup of full database(export .dmp). And after I dropped
 this
> database. After I understood that I lost one very important for me
> function and I did not save the script of its creation.
> Is that possible to retrieve single function from .dmp file or if it
 is
> impossible I would retrieve the whole database. Just tell me please
 how
> to do it.
> Thank you in advance and Merry Xmas.
> --
> Inna.Junior programmer.
>
> Sent via Deja.com
> http://www.deja.com/
>

Use
imp <username/password> file=<your dmp file> full=y show=y log=<any filename>

*All* create statements will be dumped to the file provided as log parameter, and you will need to edit this file to retrieve the source.

Hth,

Happy Holidays,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/