Re: Procedures

From: Mike Rose <mmrose_at_home.com>
Date: Sat, 13 Mar 1999 04:56:26 GMT
Message-ID: <_dmG2.7401$573.3222@news.rdc1.md.home.com>

Export the user with User = user, Rows = No, Indexes=Yes ... This will create a file that contains the procedures, then you'll have to extract them from the file. Doable but not thrilling.
Use a tool like TOAD, SQL Navigator, SQL Programmer and others that will write scripts to a file that can be used to re-create the objects in the other database.

Mike Rose

Ed Lufker wrote in message <7cccp2$99g$1_at_sloth.swcp.com>...
>Hi All:
> How do you pull out all procedures owned by one user and put the
>output into a file, so I can take it to another db and complie them there.
>I would like to use sql to do it and do it in a few steps rather than
>using OEM and doing the cut and paste thing.
>thanks in advance for any help here.
Received on Fri Mar 12 1999 - 22:56:26 CST