Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Advanced Replication of Procedures, Functions, and Packages

Advanced Replication of Procedures, Functions, and Packages

From: Chris R. Donnelly <chrisp_at_dmotorworks.com>
Date: Tue, 7 Sep 1999 17:17:33 -0500
Message-ID: <rtb3nqdv8os87@corp.supernews.com>


Hi everyone,

I have set up multimaster replication between two Oracle 8i databases. The objects I am replicating between the two masters are a table and a stored procedure. The table data is replicating normally (i.e., a change on one database propagates to the other as expected). However, when I make a change to the stored procedure on the masterdef database, it does not replicate the changes in the procedure to the other database, either automatically or by manual execution. I have tried using both Replication Manager as well as directly executing the procedures in the DBMS_REPCAT package to no avail, as well as both synchronous and asynchronous replication (preferably using asynchronous). What do I need to do to replicate the stored procedure's DDL?

// Chris Received on Tue Sep 07 1999 - 17:17:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US