Re: Moving a stored procedure

Originally posted by Tichi404_at_Yahoo.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

Let me jog your memory because view in above query "dba_source or user_source" is generally used to get to an object's source code via text column. To get a list of owners's procedures use,

select object_name
from dba_objects
where object_type = 'PROCEDURE'
and owner = 'Username who owns the object';

Although you can get a procedure's source code from dba_source and spool it to a file which can then be deployed into production *BUT* this is not the best practice of deploying code into production. Don't you have any version control in your env and does'nt the code reside in files?

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com