Updatable snapshots: HELP!

Hi all,

I am working on a project that requires an updatable snapshot mechanism. I already received some documentation from Oracle, but did not succeed in setting things up.

This is my situation:

I have 2 machines (SCO Unixware 2.1.2) running Oracle 7.3.2.3.0 server. I have the distributed and replicated options installed. I ran the installation of catrep.sql and catrepad.sql. I have created db links between the 2 machines and verified them.

All goes fine until I call the dbms_repcat.create_snapshot_repgroup at the snapshot site. There, I get the error:

*
ERROR at line 1:

ORA-23313: object group GROUP1 is not mastered at REP1.WORLD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 541
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 178
ORA-06512: at "SYS.DBMS_REPCAT", line 424
ORA-06512: at line 1

However, as I said, db links are working and I created the GROUP1 repgroup at the master site.

What can be wrong here? What options do I need to install? What settings in init.ora am I missing?

Thank y'all in advance...

Regards,
Gerco Schot
Gerco_at_lucent.com Received on Mon Nov 02 1998 - 05:42:04 CST