Re: Full Import

run imp <username/password> show=y full=y log=<any file> will dump the source code of all stored procedures (amongst others) Hth,

Sybrand Bakker, Oracle DBA

Nandakumar <N.Kumar_at_rocketmail.com> wrote in message news:8b6948$2pd$1_at_nnrp1.deja.com...
> Hi
> Is it possible to know the names of stored procedures in an export dump
> prior to importing to oracle database? If that is possible, is there a
> way to import some select procedures off the export dump into database?
> I just lost some stored procedures! I have an export taken long back
> that i am not sure if the dump has the required procedures in it.
> i'd appreciate your answers!
> --
> Nandakumar
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 20 2000 - 23:53:14 CET