Re: How to create a script from user_source?

suisum_at_freenet.edmonton.ab.ca wrote:
>
> Hi:
>
> I'm using procedure builder to create program modules. Now I have a
> problem to perform migration for the stored procedure.
>
> I consider if I can export the stored procedures to text files one by one.
> But I do need to add the line 'CREATE OR REPLACE' at the top of every
> file. I have almost 40 files.
>
> Is there any effective way to migrate the stored procedures from one
> schema to another?

Take a look at TOAD (Tool for Oracle Application Developers), available at http://www.toadsoft.com, at no cost. It is an amazing piece of software for the price (or at a higher price)! It generates scripts for most of the database objects of interest.

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Mon Oct 05 1998 - 03:26:52 CDT