Re: Moving a stored procedure

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Aug 2003 07:55:39 -0700
Message-ID: <2687bb95.0308130655.65bb3692@posting.google.com>

tichi404_at_yahoo.com (tichi404_at_yahoo.com) wrote in message news:<6ed62c1c.0308122035.19660f08_at_posting.google.com>...
> I am covering for our DBA who is on vacation - sorry if question seems
> dumb. I remember that
>
> SELECT *
> FROM sys.dba_source
> WHERE type = 'PROCEDURE'
>
> lists all the stored procedures in a database. But somone once showed
> me simple command to move stored procedure from a test database to
> production database (8i) inside sqlplus - I just can't remmber. Can
> anyone help?
>
> -- Ti

Ti, since the source is in the text column why not just spool the text to a .sql file, add the create or replace line, connect to the target db as the new owner, and submit the script. For a single procedure that is pretty easy.

HTH -- Mark D Powell -- Received on Wed Aug 13 2003 - 09:55:39 CDT