Re: Moving a stored procedure

There is no ALTER PROCEDURE MOVE command or something like that. If you were on 9i, then you could use the new DBMS_METADATA package to generate the DDL to create the proc for you. Since you are on 8i, then you'll have to query DBA_SOURCE to get the DDL to create the proc. Then save the output in a script and run the script on other instance. There are 3rd party tools (like Toad) which facilitate this.

HTH,
Brian

"tichi404_at_yahoo.com" wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"