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