Re: Exporting Stored Procedure From one Schema to Another

I believe you have. What I am trying to do is to extract the source code that I don't have
from the SQLPLUS and and then create them in the another instance. All I know from
dba_source table the name of the packages. I hope this clear my problem.
Thanks in advance.

Van Messner wrote:

> I may be misunderstanding the question. For the second instance why
> not
> just use SQL+. SQL> @ \path..\myproc
>
> Van
>
> ct001110 wrote in message <365646D9.54322F34_at_interramp.com>...
> >I hope you all can help me with this problem. I am trying to export
> all
> >Stored Procedures and Packages under one User ID on one Instance to
> >another Instance. Is it possible to extract the source code via "SQL
> >Script" and recreate them in another Instance. Your help is much
> >appreciated.
> >
> >Thanks.
> >
Received on Sun Nov 22 1998 - 16:56:26 CST