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

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

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 01, 2003 4:24 PM mastered at ORC1.WORLD

> 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).