Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> trying to setup updateable snapshots
We have a 2 tables that we'd like to replicate and sync ever X mins or
so.
I am looking at the followig documentation http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_repca2.htm#107162
so far on master site I've created snapshot log on replicating site I've created snapshots refresh fast for update
now I am trying to setup the group
BEGIN
DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
gname => 'member_list_grp', master => 'base.world', propagation_mode => 'ASYNCHRONOUS');END;
but getting
ERROR at line 1:
ORA-23313: object group "PUBLIC"."MEMBER_LIST_GRP" is not mastered at
BASE.WORLD
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 7442 ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1702 ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64 ORA-06512: at "SYS.DBMS_REPCAT", line 1262 ORA-06512: at line 2
Seems to me that I should be doing something on the master site prior to creating anything on the replicating side, however I can't find in the docs what that something should be.
Can someone please direct me into the right direction?
(btw, the link works, other non-updatable ones refresh fine, with exception of few that i now know how to fix)
Thanks!
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Fri Feb 11 2005 - 13:14:53 CST
![]() |
![]() |