Re: Moving a stored procedure

Can't imagine a "simple command in sqlplus" for this - other than as others have pointed out using sql to generate the sql command file to recreate the Plsql.

Not trying to sell any particular product, but there are many tools other than sqlplus that allow easier manipulation of PlSql. I haven't looked at Oracle's tool, but they use to have a tool (maybe in OEM now?) for editting PlSql.

There are others too, but I like TOAD (buy version from quest.com) . Also, the freeware version might be good enough for you . I use the buy version now, but you could try downloading the TOAD freeware version - simple zip file that you unzip. It is at http://www.toadsoft.com .

In the buy version (might be same in freeware), you simply open the Plsql unit in procedure editor and then click on a drop down to change database session to the new database you want to copy to and then click on compile (which of course also saves into the new database).

-- 
<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