Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a stored procedure
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