Re: copy procedures from one database to another

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Wed, 19 Jan 2000 09:28:43 GMT
Message-ID: <86403u$oo8$1@nnrp1.deja.com>

Using my freeware SQLPlusPlus, from your SQL Plus, you can execute

SQL> EXECUTE S.GETSRC to get all PLSQL source code stored in the current user schema of your database.

regards,
M. Aramghan Saqib

SQL PlusPlus: Add power to SQL Plus.
SQL Link for XL: Integrate Oracle with XL.
Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

In article <862bcp$svo$1_at_freenet9.carleton.ca>, aj739_at_FreeNet.Carleton.CA (Margaret Burwell) wrote:
>
> Please forgive me if this seems like a basic and obvious question, it
> isn't to me.
>
> I have a development database in which there are procedures which are
> owned by the user devl. I want to move them to the production
database
> where they will be owned by administrator. I don't want to export the
> entire devl schem because I will pick up tables and views I don't
want in
> the production database.
>
> Is the an easy way to move only specified procedures?
>
> Marg
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 19 2000 - 03:28:43 CST