Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting Stored Procedure From one Schema to Another

Re: Exporting Stored Procedure From one Schema to Another

From: Van Messner <vmessner_at_netaxis.com>
Date: Sat, 21 Nov 1998 11:20:09 -0500
Message-ID: <9OB52.953$ED5.2512@news6.ispnews.com> 





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 Sat Nov 21 1998 - 10:20:09 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US