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

Home -> Community -> Usenet -> c.d.o.server -> How do I transfer stored procedures between databases

How do I transfer stored procedures between databases

From: Douglas C. Hay <doughay_at_compusmart.ab.ca>
Date: 1996/11/13
Message-ID: <01bbd1ba$ae9bf800$0300c881@DougOffice.compusmart.ab.ca>#1/1

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 Received on Wed Nov 13 1996 - 00:00:00 CST

Original text of this message

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