Re: How to retrieve function from .dmp file

In article <922j81$act$1_at_nnrp1.deja.com>,   sybrandb_at_my-deja.com wrote:
> 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/
>

Thank you very much and Happy Holidays!!!!

--
Inna.Junior programmer.


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