Re: Importing Stored Procedures

A full import of a full export will import the stored procedures/tiggers, etc.

Terry Ball
Sr. DBA, CSG Systems

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 Thu May 06 1999 - 11:09:40 CDT