Re: Importing Stored Procedures

Hi

If you do a full user export, all the objects owned by the user are exported (including stored procedures, sequene, triggers, etc). When you import all the exported stuff are automatically created

Its a pity that Oracle hasn't given EXPORT stored procedure option in the export utility. Probably Oracle can treat this as a request and incorporate it.

Regards

N.Prabhakar

as wrote:

> Hi - I'm a newbie to oracle (7.3.4 running on unix)
>
> Q: I would like to know how to restore the stored procedures from the
> exp(orted) file. I have set up a parameter file for the imp command to
> restore certain tables from a full exp. of the database. There is a setting
> to ignore or import "grants", "indexes",etc but no talk of stored procs. If
> I do a full import will these stored procs also be imported or do I have to
> run the stored proc DDL's after the database is imported. Can this be done -
> I need to get the stored procs off the exported file or is it a separate
> task? Do the stored procs get exported in a full export?
>
> Many TIA
> Andre
> South Africa

Received on Fri May 07 1999 - 02:47:19 CDT