Re: backup/restore

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 5 Nov 2002 23:12:01 +1000
Message-ID: <BnOx9.69785$g9.198078@newsfeeds.bigpond.com>

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:aq87u7$3bn$1_at_reader1.imaginet.fr...
> Hi,
> I've got a backup file (dmp file) and I want to restore one of my
procedure
> which have been deleted.
> I know how to restore one table : imp ME/MYPASS_at_MYBASE table=MYTABLE
> FROMUSER=OTHER TOUSER=ME
> or many : imp ME/MYPASS_at_MYBASE table=(MYTABLE1,MYTABLE2) FROMUSER=OTHER
> TOUSER=ME
>
> but not a proc
>
> So if you can help me
> thx
>

Hi There,

You can't directly.

However, what you can do is perform an export with show=y and suck out the details of the procedure in question.

Cheers

Richard

>
>
Received on Tue Nov 05 2002 - 07:12:01 CST