Sami,
Setting up replication is pretty straight forward as long as you follow all
the steps dilligently. Unfortunately if a step is missed, it's hard to
diagnose the problem until one is at the terminal looking at the actual
database. In this case there are several steps that my not have been
correctly executed. Here are some:
(1) Have you built the replication support for the master group?
begin
dbms_repcat.generate_replication_support(
sname=>'HR',
oname=>'DEPATMENTS',
type=>'TABLE',
min_communication=>TRUE);
end;
(2) Have you started replication activity?
begin
dbms_repcat.resume_master_activity(
gname=>'HR_REPG');
end;
(3) Have you created the snaphsot group at the MV Site using
dbms_refresh.make?
You should do this steps before you create the MV RepGroup. You may find an
article I wrote for DBAZine (http://www.dbazine.com/nanda2.html), a related
but separate issue. And please let us know your progress.
HTH.
Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 5:09 PM
mastered at ORC1.WORLD
> Dear Arup,
>
> Thanks for your response. But i have done the same
> which is mentioned in page # 3-6(Replication API
> Reference Manual). Please see below. What else could
> be wrong? TIA
>
> CONNECT repadmin/[EMAIL PROTECTED]
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPGROUP (
> gname => 'hr_repg');
> END;
> /
>
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
> gname => 'hr_repg',
> type => 'TABLE',
> oname => 'departments',
> sname => 'hr',
> use_existing_object => TRUE,
> copy_rows => FALSE);
> END;
> /
>
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > 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"
> > <[EMAIL PROTECTED]>
> > 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/[EMAIL PROTECTED]
> > > 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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
>
>
> __________________________________
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
