You can create a job that extract the ddls from the procedures and run in another database, this is so simple. Now if the data is in one database only, then only call the database through a dblink. Juan Carlos Reyes Pacheco OCP -------Original Message------- From: oracle-l@xxxxxxxxxxxxx Date: 09/02/04 16:30:00 To: oracle-l@xxxxxxxxxxxxx Subject: REPLICATION (816) of functions/procedure Hi, I want to replicate couple of functions and procedure from one database to another database.how to do this? thx _________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004 --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004