Re: How do I transfer stored procedures between databases

In article <01bbd1ba$ae9bf800$0300c881_at_DougOffice.compusmart.ab.ca>,

   "Douglas C. Hay" <doughay_at_compusmart.ab.ca> wrote:

Drag and Drop with procedure builder might be the easist way, although I don't recommend PB for normal use.

Otherwise, create a suitable SQLPlus script which queries the user source table and appends a CREATE OR REPLACE statement at the top.

>Is there any way to export/import only the stored procedures for a specific
>user. I am currently developing a system in a Windows95/Sun-Unix
>environment at work. I am trying Personal Oracle at home to allow me to
>continue work at home when required. I am working quite extensively with
>the stored procedures and would like to be able to simply export a copy to
>transfer between home and work. I currently export individual procedures
>to text files and transfer one at a time. This is becoming increasingly
>painstaking as the number increases.
>
>Maybe someone has a utility or is there a specific table that could be
>exported. (NOTE: I would prefer not to have to export and import all the
>procedures associated with the designer repository(different user).
>
>THNX
>doughay_at_compusmart.ab.ca

Miles Thomas
Logica UK Ltd
thomasm_at_logica.com
The above are personal opinions, and are not necessarily the opinions of my employer. Received on Tue Nov 19 1996 - 00:00:00 CST