Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

From: Arup Nanda <orarup_at_hotmail.com>
Date: Mon, 01 Sep 2003 12:54:25 -0800
Message-ID: <F001.005CE73C.20030901125425@fatcity.com>


Before you create the Materialized View Group, you must create the REPGROUP at the Master site, which in you case is ORC1.world.

In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure DBMS_REPCAT.CREATE_MVIEW_REPGROUP. HTH. Arup Nanda

> Hi list
>
> I am using Oracle 9.2.0.1.0 enterprise on windows.
>
> I am going thru the examples provided in "Replication
> Management API Reference-Part No. A96568-01".
>
> While creating MVIEW REPLICATION GROUP, getting the
> following error (page # 5-7)
>
>
> SQL> CONNECT mviewadmin/mviewadmin_at_mv1.world
> Connected.
> SQL> BEGIN
> 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> 3 gname => 'hr_repg',
> 4 master => 'orc1.world',
> 5 propagation_mode => 'ASYNCHRONOUS');
> 6 END;
> 7 /
> BEGIN
> *
> ERROR at line 1:
> ORA-23313: object group "PUBLIC"."HR_REPG" is not
> mastered at ORC1.WORLD
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> ORA-06512: at line 2
>
>
> Any help would be really greatful.
>
> Thanks
> Sami
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Oracle DBA
> INET: sami_resume_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 01 2003 - 15:54:25 CDT

Original text of this message

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