Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems with replication (oracle8i)
Carlos,I would first check that schema at Kepler which database link uses
has proper privileges.Also if check if syntax is correct i.e oracle is
expecting schemaowner.object,try qualifying scott_mg with schema owner.
Anwer
Carlos Matsuki wrote in message ...
>Hi,
>
> i have the following problem: I followed the step from Oracle8i
>replication management API Reference to test the replication between
>ORACLE databases, using only 1 database master and 1 snapshot
>database, but when I tried to create a snapshot group associating with
>the master replication, occurred the ORA-23313 (not mastered), but
>this master replication exists, as follow:
>
>-- as snapadmin from snapshot database
>SQL> BEGIN
> 2 DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP (
> 3 gname => 'SCOTT_MG',
> 4 master => 'KEPLER',
> 5 propagation_mode => 'ASYNCHRONOUS');
> 6 END;
> 7 /
>BEGIN
>*
>ERROR at line 1:
>ORA-23313: object group "PUBLIC"."SCOTT_MG" is not mastered at KEPLER
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
>ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2140
>ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1536
>ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
>ORA-06512: at "SYS.DBMS_REPCAT", line 1045
>ORA-06512: at line 2
>
>-- as master database
>SQL> select * from dba_repgroup
> 2 where sname = 'SCOTT_MG';
>
>SNAME M STATUS
>------------------------------ - ---------
>SCHEMA_COMMENT
>---------------------------------------------------------------------------
![]() |
![]() |