Could also use DB link and DBMS_SQL.

Could also use:
set long 1000000 heading off
spool somefile.sql
select dbms_metadata.get_ddl('PROCEDURE','&PROC_NAME','&PROC_OWNER') FROM
DUAL;
spool off

-----Original Message-----
From: Titus Olowok
[mailto:oracledba-ezmlmshield-x65531204.[Email address protected]
Sent: Tuesday, August 31, 2004 3:46 PM
To: LazyDBA Discussion
Subject: Re: How to copy Procedure into a another DB.


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


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


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Oracle LazyDBA home page