Re: PACKAGES

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 09 Aug 2005 07:25:45 -0400
Message-Id: <s2f85a8b.030@glcclst_gw.galottery.org>

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

Received on Tue Aug 09 2005 - 06:28:15 CDT