Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Advanced Replication of Procedures, Functions, and Packages
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
![]() |
![]() |