RE: PACKAGES

This also works nice

sql> set pagesize 0
sql> set long 90000
sql> select dbms_metadata.get_ddl('PROCEDURE', proc_name, owner) from dual;

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ron Rogers Sent: Martes, 09 de Agosto de 2005 06:26 a.m. To: oracledbam_at_hotmail.com; fairlie_r_at_yahoo.com Cc: oracle-l_at_freelists.org
Subject: Re: PACKAGES

How about selecting the text from dba_source where name ='PACKAGE IN QUESTION' and then running the sql on the other server. It also is a good method of documenting the database. Ron

>>> fairlie rego <fairlie_r_at_yahoo.com> 08/08/05 11:37 PM >>>
Hi Seema,  

You can use procedural replication.
Unfortunately I do not have an example on hand but you can refer the documentation
at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96568/rarmanma.htm#22542  

Section: Using Procedural Replication

Regards,

Fairlie

Seema Singh <oracledbam_at_hotmail.com> wrote: Hi,
I want to copy 1 package from one database to another. How can I do that?

how can we setup replication for package/procedure/functions? thanks

--
http://www.freelists.org/webpage/oracle-l 


Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
www.optus.com.au 
Mobile: +61 4 02 792 405

 
When I read about the evils of drinking, I gave up reading.





		
---------------------------------
 Start your day with Yahoo! - make it your home page 

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l