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 -> trying to setup updateable snapshots

trying to setup updateable snapshots

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 11 Feb 2005 19:14:53 GMT
Message-ID: <420d0283.771294172@localhost>


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

Original text of this message

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