set pages 0 lines 150
spool <spool_file_name>.sql
select text from dba_source
where name = '<PROCEDURE_NAME>'
and owner = '<PROCEDURE_OWNER>';
spool off

This gives the source code of the procedure/package. Edit as appropriate and
copy over to target DB

Hope this help

Titus Olowok
Oracle DBA
Atlanta, GA

----- Original Message -----
From: "Derrick Pitts "
<oracledba-ezmlmshield-x32389140.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 31, 2004 4:15 PM
Subject: How to copy Procedure into a another DB.


> Gurus,
>
> What is the easiest way to copy a procedure into a different DB?
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page