Re: How to Imp/Exp Stored Procedures?

You can move just the procedures with TOAD. You can download an evaluation copy from Quest software (http://www.quest.com/toad/)

In article <39773387.FAB42A74_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> You can not export just the stored procedures. If you export an entire
> user, then that user's procedures will get exported as well. You will
> also get the procedures when you export a full database. You will NOT
> get procedures when you export a list of tables.
>
> If you want to move just the procedures, it's easiest to just reverse
> engineer the create script and run the script on the new system.
>
> HTH,
> Brian
>
> dorutanasa_at_my-deja.com wrote:
> >
> > Hello all,
> >
> > I want to know how to exp export the stored procedures from an
 oracle
> > database. And then to import them in another one. Can this be done
 or I
> > have to save these procedures and then to compile them in the new
> > database? If so how do I select all procedures to a single file?
> >
> > Thank you,
> > Doru.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 24 2000 - 00:00:00 CDT